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

    Calculation Avg(Values) by Date

    Tina Crouse
      Market17-Feb17-Mar17-Apr17-May17-Jun17-Jul17-Aug17-Sep17-Oct17-Nov17-Dec18-Jan18-Feb
      CO90.599.693.8100.699.594.897.790.99688.4108.987.255.4

       

      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.