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
Oct 19, 2020 06:03 PM
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
Oct 19, 2020 11:14 PM
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)