Hi Friends,
Could you please help this Issuse
PY (2015). In the enclosed example for China, you see a difference (123,445m€ in EIS and 123,130m€ in MMV).
I think the problem is, that the 123,445m€ includes the turnovers from Industrial Business Area. The 123,130m€ in MMV only shown the Country Group China / Business Area M – Marketing / Business Unit AP, which corresponds to the Actual / Budget figures. My opinion is, to show the correct PY figures is, that only Business Area M and Business Unit AP should be included in the figures (see picture below).
This PY Expression:
Pick(
Only({1}OrganisationDetails.flagEmptyRow )+1,
Sum(
{<
VersionKey={'PY'},
YearMonthWeekKey ={'>$(vYMW_FyPy_Start_Closure)<$(vYMW_FyPy_End_Closure)'},
Month,
BaseYearKey={$(=constBaseDate_YearNum-1)}
>} #Values
)/vSelect_ScalingFactor,
''
)