Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Formula result not being recognized as a number?

Topic Labels: Formulas
130 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Hello :slightly_smiling_face:

I have this formula to calculate Manpower/Days/Hours and a Rate into a dollar amount here:
IF({MP/Day} > 0, {MP/Day} * Days * Hours * Rate,“0”)

and it works! However it’s not being recognized by Airtable as a ## therefore I cannot get a sum, and it also doesn’t show commas when I’m using the field to generate totals in an interface.
I figure I could play around with the formatting to get commas etc. but for the life of me I cannot figure out why it is not being recognized as a number that I can add up a total of?

Thank you!

2 Replies 2

Hi. Just change your “0” to 0. See if that solves it. Cheers.

LMAO. I can’t believe it was that simple. Thank you so much!!