Interface: Cannot use formula result in Number Element

[Gavin_Andrews]

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?

[kuovonne]

Welcome to the Airtable community!

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

[Gavin_Andrews · Accepted solution]

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.

[1234567890]

Have a good time, my beautiful friend. With you is Abu Wadih from Syria. Can we be friends?