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!