3 Replies Latest reply on Aug 31, 2018 6:13 AM by Naveen B

    YoY

    Josephine de Guzman

      Hi,

       

      For some reason I'm not getting the correct value of my YoY calculation, can you help me identify where am I wrong.

       

      YOY in % formula :

      (IFNULL(([_YTD Actual]),0)-IFNULL(([_PY YTD Actual]),0))

      /IFNULL(([_PY YTD Actual]),0)

       

      It should just be as simple as

      (406645-656725)/656725

       

      Appreciate the help.

        • 1. Re: YoY
          Naveen B

          Hi Josephine,

           

          Use the sum in the below calcualtion

           

          (SUM(IFNULL(([_YTD Actual]),0))-SUM(IFNULL(([_PY YTD Actual]),0)))

          /

          SUM(IFNULL(([_PY YTD Actual]),0))

           

          This will give the required value if the _YTD Actual and  _PY YTD Actual is showing as SUM aggregation in Measure values instead of AGG

           

          If it didnt help kindly attach a workbook with some sample data

           

          If it helps plz mark this answer as correct and helpful to close the thread

           

          BR,

          NB

          1 of 1 people found this helpful
          • 2. Re: YoY
            Josephine de Guzman

            it worked. thanks!

            • 3. Re: YoY
              Naveen B

              Hi Josephine,

               

              If it helps kindly click on the below link and mark it as correct so that it will be helpful who are looking for the same answer.

               

              YoY

               

              BR,

              NB