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 ?
Solved
Simple division does not work
Best answer by Julian_E_Post
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.
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.
Julian_E_Post wrote:
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.
Thank you very very much. you saved me.
1 person likes this
Reply
Most helpful members this week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.