0

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

null
    • Alain_Bureau
    • 5 yrs ago
    • Reported - view

    let myId := number(Id);
    sum((select RunTotal where number(Id) <= myId).(Depot - Retrait))

    • Ninox partner
    • RoSoft_Steven.1
    • 5 yrs ago
    • Reported - view
    • Ninox partner
    • RoSoft_Steven.1
    • 5 yrs ago
    • Reported - view

    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

    • Alain_Bureau
    • 5 yrs ago
    • Reported - view

    Good stuff. Thank you very much

Content aside

  • 5 yrs agoLast active
  • 4Replies
  • 2089Views