I’m trying to do a fairly basic calculation that is conditional on a percentage field - if the percent is above a threshold, return a calculated number, if below return 0. My formula works with anything except zero for value 2.
Could you please clarify what you mean by this? Which value is “value 2”?
Going off of your subject line—re: the formula not returning an integer—one thing to keep in mind is that you can control the display formatting of a formula that outputs a numeric value. To adjust this, open the formula field settings, then click on the “Formatting” tab. There you can choose whether the field displays a decimal value or an integer.
Keep in mind that this formatting control is for display purposes only. Internally the calculated value is likely stored as a decimal, and will return as such to any other formula that asks for it. If you want other formulas to treat the output from this one as a whole number, wrap your current formula in one of Airtable’s rounding functions.
I saw your reply the first time. No need to repeat it.
That’s very strange. The formula syntax looks fine. I created that same formula myself and didn’t get any error indicator.
The first thing to try is to shut down and restart your browser (or the standalone app if that’s what you’re using). Sometimes a browser that’s left open too long can cause unexpected things to happen with Airtable. I’ve seen it firsthand on more than one occasion, and a restart of the browser is the only thing that will cure some ailments.
If that doesn’t fix it, try retyping the formula from scratch in a new formula field. If it gives the same error there, definitely report it to Airtable support.
I wish that I had more to suggest, but this is truly one of the most bizarre errors I’ve seen.