#ERROR! Returned when dividing two fields

Hi, I am trying to divide two fields using the following formula:


However I am returned a #ERROR!. I have checked and both fields are coded as Integer types and no value in “Variable2” is a zero.

Can you help me find out why I’m being returned this error?

You said that the formatting of both variable fields is set to Integer, but you didn’t say what the field types were. Are they manual entry fields (number, currency, percent, etc), or calculated fields (formula, lookup, rollup, etc.)?

One way to force Airtable to see the contents of a field as a numeric value is to wrap the field name in VALUE():

VALUE({Variable 1}) / VALUE({Variable 2})