formula revision for QTR last year
I would like to ask advice on formula revision of my clients report. Below is the target module. The column of last year is where we are encountering a problem.
Requirement: it is supposed to pick up the value from the source module but the total QTR of last year.
Target module: OUT007
In the target module if I select Q2 FY22 it should capture the value from the source module Q2 FY21. As seen below. It should be 26, 759 instead of (53,517).
Source module: Cal001
The current formula on the target module seems to be referenced to the wrong target module.
Current Formula of Last Year column: MOVINGSUM('OUT006 Corporate Expense - Net MTD'.Actual CY, -11 - MonthNum, -12, SUM)
Do I just reference it to the correct source module and retain the formula? Or revised the entire formula to capture the total per QTR.??
Hope you can provide some insights on the matter. Thank you in advance for any comments regarding the matter.