Interface: Cannot use formula result in Number Element

I am using a formula to subtract one weight (ungraded weight) from another (graded weight). The formula in the dashboard is working fine to make Unaccounted Weight:

However, I cannot choose Unaccounted Weight in Interface Designer. I want it to appear just as a number element.

Does anyone know what I’m doing wrong?

Welcome to the Airtable community!

It looks like your number element is connected to “Grading Lots”. Is your {Unaccounted Weight} in a different table?

It is in the same table. It only shows fields that are linked records. No idea why.

However, I was able to make it work by using field elements.

1 Like

This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.