7 Replies Latest reply: Sep 30, 2014 1:49 AM by Prashant Sangle RSS

    Calculate average per month based on the count of months

      Hi there,


      I'm trying to calculate an a !verage per month (= the sum of ... divided by number of months available) but it doesn't work. Anyone any suggestions what I'm doing wrong?


      If (in a text box) I apply the calculation "count(distinct(Month))" it gives me the number "2" which is correct since there are only two months of data available. However, applying the same expression in a pivot table doesn't work.


      Much appreciated if someone can guide me into the right direction.