I know this is going to be something simple, but I have been stumped for hours, I have tried so many different select formulas and have now just created a virtual column to first make a list of the values from the other table instead, I am trying to do a simple Balance Due Column that subtracts the list of payment amounts from the Invoice Amount Column, please help:
I have checked that all of my data types that I am creating the list from are all Price.
Thanks
Solved! Go to Solution.
[Balance Due] should probably be a virtual column, not a real column. Are you aware of the difference in when they evaluate?
[invoice Amount] - SUM( [Related Payments][Payment amount] )
https://help.appsheet.com/en/articles/2357307-sum
https://help.appsheet.com/en/articles/4575708-list-dereference
User | Count |
---|---|
17 | |
11 | |
7 | |
5 | |
5 |