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

Conditional calculation formulas, or formulas using formulas?

Topic Labels: Formulas
284 1
cancel
Showing results for 
Search instead for 
Did you mean: 

Thanks for being here!
I’m trying to calculate weekly sales as a percentage of monthly sales goals. I’ve made a conditional formula to populate sales goals according to month, and my formula is accepted but only returns errors.

I’m also wondering if I can bypass the separate sales goals field and embed the formula into a calculation, i.e., can I say that IF {Month} is MM/YYY, {Current Month Sales}/‘XXXXXX’

If not, I’d like to just be able to calculate simple division, but that doesn’t seem to be working either.

Heather
Screen Shot 2020-10-19 at 6.00.27 PM Screen Shot 2020-10-19 at 5.49.16 PM

1 Reply 1

First Screenshot: looks like {Monthly Goal} returns a string and not a number, what’s that field’s formula?

Second Screenshot: You have a random ( to start the second argument of the IF() statement and you’re wrapping the rest of the second argument in quotes when it shouldn’t be (you are doing math, not outputting a string. Only use quotes if you mean “insert this exact text no matter what it is”). A proper IF() would be: IF({MONTH}='10/2020', {Current Month Sales}/85825)