We have one requirement to calculate Rolling Period (R2/R3/R12) based on range of Fiscal year Period and have to sum up based on R2/R3/R12.
Example. FiscalyearPeriod range: 002.2022 - 008.2022
FiscalyearPeriod GC Amount R2 R3
002.2022 10 10 10
003.2022 20 30 30
004.2022 30 50 60
005.2022 40 80 90
006.2022 50 90 120
We can find out the amount for each period. But while going to sum for (Amount of curre period+Amoung for Prev Period), it's not happening. Means we are not getting the added values rather for each period amount is displaying only.
If you provide any idea or solution to resolve then it will be much appreciated.
Hoping for your response here.
Thanks in Advance,