I have an column with an app formula in which...

I have an column with an app formula in which I am subtracting the value of one column from another . All three columns I am using are number type columns but I am getting this error "The expression is valid but its result type ‘List’ is not one of the expected types: Number ". Any ideas why?

0 5 326
5 REPLIES 5

Try [_THISROW].[COLUMN NAME]

sorry I guess i should have been more specific. the columns i am trying to get the difference of are referenced from another table.

here is the formula a using: CLOSE CODED BEER[AMOUNT IN CASES] - CLOSE CODED BEER[CLAIMED CASES]

If the Ref column is CLOSE CODED BEER, try

[CLOSE CODED BEER].[AMOUNT IN CASES] - [CLOSE CODED BEER].[CLAIMED CASES]

that works thanks!

@Lindsey_Allen yes, so that type of setup TABLE[COLUMN]

is the entire column from that table… So appsheet sees that as a list of values. If you want to sum each of those values then do your math?

Top Labels in this Space