Measure value not showing properly- MFP
RPAS Version - 16.0.2
MFP Version- 16.0.2
Rules:-
SlsBR = prefer(SlsTR/Laslstr)
Laslstr = if(current == first, TslsTR, lag(SlsTR))
TslsTR <- timeshift(SlsTR.master,-1)
For SlsBR measure the week level data looks fine. It is calculating as per the rules when it is present as first period or as any Nth period in the workbook.
At aggregated levels (like, month, qtr,ssn), the data is not getting calculated correctly when it is present as first period.
SlsBR's aggregation method is recalc and it should take the sales value at aggregated level and recalculate.
But it has taken the average of the week value and is putting it in the month and similarly for qtr and season.