1 Reply Latest reply on May 16, 2018 3:17 PM by Jennifer VonHagel

    Calculation Avg(Values) by Date

    Tina Crouse


      I have a bar chart in my data and I show the values by year and month. I have this calculation: IIF([YEAR] = {MAX([YEAR])}-1,[Values],0)


      I have another calculation IF ATTR(YEAR([Yr Mth])) = 2017 THEN SUM([Values]) END

      This calculation does not error but when I put it in the chart it automatically changes it to AGG and I noticed the line changes to 58.4 as the value in the reference line and I am actually looking for the summation of the values for the year 2017 then I want to AVG those and the ------------------------------ reference line should say 96.4 because it is the values from Feb to Dec 2017. Then divide by 11.