Maximum value does not match

[mgalihm]

Hi everyone,

I have a trouble with setting the maximum value of number entry.
I create the number entry, then I set the maximum value from the column with number like this

but the maximum value does not match, it has more decimal number like this

How to fix it?

[Darren_Murphy]

Looks like a floating point arithmetic issue.

You said the max value comes from a “column with number”. Is that a Math column, or the result of a math formula? Assuming yes, use a Round() function in your Math formula to force the precision to zero decimal places.

[mgalihm]

yes that was a math column

but still the same

[Darren_Murphy]

Did you add the Round() function like I suggested?

Your formula should look like:

Round(invoicenom*(1+margin),0)

Or you could use:

Trunc(invoicenom*(1+margin))

Either way should work.

[mgalihm]

Thank you, it works