Decimal type limitation

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

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

3 Likes

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

2 Likes

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.

3 Likes

Interesting, and unfortunate. :frowning:

2 Likes