Simple division does not work

2 fields, both are integer
A = 35000
B = 86400

Formula A/B giving result 0 where it should be 0.40

How can I achieve result ?

Hi Manish,
It may have to do with the number formatting. The system is rounding 0.4 to 0, since it thinks that you want an integer value. Right click on the field and choose ‚ÄúCustomize field type‚ÄĚ. Then look for the formatting tab toward the bottom. This will allow you to make the resulting value a decimal and how many decimal places.

1 Like

Thank you very very much. you saved me.

1 Like

This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.