Incorrect Numeric Values

[Suseendran]

Hi Team,

i have done one workflow , how can i avoid above mentioned (-2.17265E-05) this kind values.

But when the same process i have done in excel these values automatically converted as 0

Please help me.

By suseendran

[atcodedog05]

Hi @Suseendran 

You can use ToNumber() to convert -2.17265E-05 to numeric

And set the datatype to fixed decimal and set the number of decimals (refer below) 15 is number of decimals

Hope this helps : )

[Suseendran]

Hi,

When i try ToNumber() convertion , i'm facing this problem

[atcodedog05]

Hi @Suseendran 

Can you please provide some sample input and expected output.

[atcodedog05]

Hi @Suseendran 

Try this formula

ToNumber(Trim(ToString([Field1])," "))

Hope this helps : )