HOW CAN I SAVE THE PREVIOUS/YESTERDAY BALANCE

Posted 1 week ago by EMfinanga

suppose you have an closed balance for Today= 100usd, and you want to use this balance for tomorrow as per formula below.

to get Today Closed balance the formula looks like:

              todayClosedBalnce=   {{number_format(($totalpayment+$totalAmount)-$totalexpenses,2)}}

to get Closed balance for tomorrow the formula looks like:

{{number_format(($totalpayment(current)+$totalAmount(current)+YesterdayClosedBalnce)-$totalexpenses,2)}}

how can i save the yestaday balance then i will add for next day

Please sign in or create an account to participate in this conversation.

Reply to

Use Markdown with GitHub-flavored code blocks.