0
Sums and Counts based on a text status
I am trying to total the value of some invoices based on the status, like "Paid", "Overdue", etc. Ive tried some simple formulas with various adaptions and they are still not working, any suggestions on what im doing wrong?
2 replies
-
Try this:
sum((select Invoices)[text('Invoice Status') = "Paid"].'Net Total')
-
Thank you Nick, works perfect.
Content aside
- 4 yrs agoLast active
- 2Replies
- 728Views