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

expressions
(Lindsey Allen) #1

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?

(Grant Stead) #2

Try [_THISROW].[COLUMN NAME]

(Lindsey Allen) #3

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]

(Bellave Jayaram) #4

If the Ref column is CLOSE CODED BEER, try

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

(Lindsey Allen) #5

that works thanks!

(Grant Stead) #6

@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?