Help

Re: Simple division does not work

Solved
Jump to Solution
524 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Manish_Patell
5 - Automation Enthusiast
5 - Automation Enthusiast

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 ?

1 Solution

Accepted Solutions
Julian_E_Post
8 - Airtable Astronomer
8 - Airtable Astronomer

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.

See Solution in Thread

2 Replies 2
Julian_E_Post
8 - Airtable Astronomer
8 - Airtable Astronomer

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.