Hi all,

I have one field that holds ENROLLMENT (total students enrolled, formatted as an integer number) and another field that holds RACE (total number of students of a given race, also formatted as an integer number). I need a field that calculates % RACE, so I formatted that field as a formula, then used the field selector to select RACE / ENROLLMENT (which airtable writes as {RACE} / ENROLLMENT). However, it gives 0 all the way down the table. All other operations (+, -, *) give accurate values if I replace the division bar with those symbols.

Any idea why trying to do division returns 0s? (None of the values in the ENROLLMENT or RACE fields are 0.)