expression is testing fine, but value is not showing up in the app

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:

SANDRALAICHE_0-1659492318116.pngSANDRALAICHE_1-1659492356150.pngSANDRALAICHE_2-1659492383673.pngSANDRALAICHE_3-1659492441554.png

I have checked that all of my data types that I am creating the list from are all Price.

 

Thanks

 

Solved Solved
0 3 135
1 ACCEPTED 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

 

View solution in original post

3 REPLIES 3
Top Labels in this Space