Converting a decimal number that is stored as a strong to an int or currency

Like (0) Share

Report

Posted on 16 Apr 2020 04:09:11 by Nithin_Vanam

Hello,

I am trying to convert a decimal number (Ex: 1234.1) that is stored as a string in a CDS field to an integer or currency value to store in a currency field.

I used the int() to convert and i had no issue if the value is without a decimal like 1234 however the int() fails when it has decimal value like 1234.1 . The error message i get is :

Unable to process template language expressions in action 'Create_New_WBC' inputs at line '1' and column '44099': 'The template language function 'int' was invoked with a parameter that is not valid. The value cannot be converted to the target type.'.

My flow action where i am using the int()

Int Function Flow 1.png

Any suggestions on how i can convert this string to an integer or a currency? Thanks in advance.

All responses (5)

Answers (1)

Verified answer

DeepakS 2,301 Most Valuable Professional on 16 Apr 2020 at 04:24:28

Like (1)

Report

Re: Converting a decimal number that is stored as a strong to an int or currency

Hi @Nithin_Vanam

Try following expression :

if(contains(string(outputs('decimalnumber')),'.'),split(string(outputs('decimalnumber')),'.')[0],outputs('decimalnumber'))

(outputs('decimalnumber') is my variable that contain number (decimal or non decimal) replace this with your variable or field.

-------------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.