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?
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?
User | Count |
---|---|
63 | |
25 | |
14 | |
11 | |
6 |