Power Platform Community Forum Thread Details

Hi all,

I'm building leave tracking App. I don't know how to calculate balance because it includes the carry forward amount from the previous year. The first year, there is no carry forward amount allowed, from the second year, the carry forward amount will be max 6 of the ending balance of the previous year. The result I wanted should be as the table below.

Total opening balance for the year = Carry forward amount + Amount granted for the year
The amount granted for the year is 18
Amount used from SharePoint list record
I need to calculate carry forward amount and ending amount for the year