3 Replies Latest reply on Apr 10, 2017 10:19 AM by Robin Fay

    Summarizing AGG calcuation by Year

    Robin Fay

      I am having trouble summarizing a calculation by year

       

      I am trying to show bias of a forecast over time using the following equation.

      (ZN(SUM([Actual]))-ZN(SUM([FC])))/ABS(ZN(SUM([Actual]))-ZN(SUM([FC])))

       

      if Forecast is higher than actual the result will be -1

      if Actual is higher than Forecast the result will be 1

      if  Actual is equal Forecast than the result will be 0

       

      When I sure the Row Grand Total I get the correct answer,(if I choose "sum" from the "total using" under Analysis>totals)

       

      What I want to do is remove the Month from the view and summarize by year (so i can select customer month ranges), However when I do that The results are all wrong.

      any ideas to show the summarized monthly bias by Year?

      LOD maybe?