Decimal type limitation

[Matheus_Souza]

Hello everyone. I’m trying to use a constant number in an expression, the number is 0.00000055. But I keep getting the error:

Constant value ‘5.5E-07’ is not in a valid format for column type 'Decimal’

Is this a limitation of the platform?

Thank you

[Steve]

You may need to make sure Decimal digits is set to allow the value (believe it or not):

[Matheus_Souza · Accepted solution]

I tried this. Didn’t work.
The workaround was to write it as 5.5/10000000. It’s working now.

[LeventK]

I believe it might be a Decimal Float issue in the back-end, and your approach is correct. I was about to propose the same math.

[Steve]

Interesting, and unfortunate.