0
Checkbook
I want to create a simple checkbook with Colums balance, deposit and debit. Each entry will generate a new balance but that balance relies on the balance from the prior record. How do I access the balance from the prior record. Balance new = balance prior record + deposit or - debit
2 replies
-
I'm using something like this, based on line id:
Formula field (i.e. Running Balance)
----
let myID := Id;
let previousB := sum((select Checkbook)[Id <= myID].Debit);
let previousC := sum((select Checkbook)[Id <= myID].Credit);
round(previousB - previousC, 2)----
-
Thank you. That worked.
Content aside
- 5 yrs agoLast active
- 2Replies
- 1003Views