0 Replies Latest reply: Mar 1, 2017 7:46 AM by Nirmala Dolly RSS

    Yearly Closure 2016, the figures of 2015 and 2016 are not on the latest Status?

    Nirmala Dolly

      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).

      Capture.PNG

       

      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,

        ''

      )

       

      Capture1.PNG