Bank Account Register
I have one table with 3 fields. Depot, witdrawal and Balance. Balance is a formula field. What should the formula be in the Balance field to maintain a correct balance as records are added in the table. I have spent hours without luck to figure it out with the basic documentation provided by Ninox. Thank You for your held
4 replies
-
let myId := number(Id);
sum((select RunTotal where number(Id) <= myId).(Depot - Retrait)) -
Something like this : https://www.dropbox.com/s/e4uvzb2miw5jzl8/Bankaccount.ninox?dl=0
-
If you want, you can change the formula of Balance in the above example by this to hightlight in green or red depending on positive or negative result :
let Total := 'Total Deposits' - 'Total Withdrawals';
if Total > 0 then
styled(text(Total), "green")
else
styled(text(Total), "red")
end -
Good stuff. Thank you very much
Content aside
- 5 yrs agoLast active
- 4Replies
- 2092Views