Maximum value does not match

Ask for Help
1

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
image
but the maximum value does not match, it has more decimal number like this
image

How to fix it?

2

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.

3

yes that was a math column

image
image344Ă—524 16.8 KB

but still the same

4

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.

5

Thank you, it works