3 Replies Latest reply on Dec 1, 2016 8:00 AM by brenda.kimiywi

    Metric disappears when I roll up months to years

    brenda.kimiywi

      Hi,

       

      I have a data set which takes into account activity month1, month2, month3...etc from when a customer joins. The calculated metric works well when I display the data monthly but it is blank when I roll up the months to years. Below is the formula I used to achieve this.....

       

      IF(DATEDIFF('month', ATTR([First Survey Finish Date]), TODAY())) >= 1 THEN

          SUM([Mth 1]+[Mth 2]+[Mth 3]+[Mth 4]+[Mth 5]+[Mth 6]+[Mth 7]+[Mth 8]+[Mth 9]+[Mth 10]+[Mth 11]+[Mth 12])/SUM([Actives])

      ELSE NULL

      END

       

      Thanks