1 Reply Latest reply on Sep 4, 2016 10:11 PM by Shinichiro Murakami

    Average + Min Differences

    Railey Abdullah

      Hi All,

       

      I have a data set as per below, my Objective is I need to take the Average of year 2017 - Average of year 2016

      and the average calculation is based on what month that user choose

      I.E : If user choosed JAN FEB MAR and APR, I need to take sum(total) + Min(Month Key for year 2017)Last Month Total

      and divide by Countd(Month Key) + 1 (Highlighted in Yellow)

      Minus

      sum(total) + Min(Month Key for year 2016)Last Month Total

      and divide by Countd(Month Key) + 1  (Highlighted in Red)

       

       

       

      I managed to get both of the average as below and try to get the difference using the calculation

      but I cant get the differences. As u can see the data become null

       

       

       

      Do anybody have any idea to do this?

       

      Thank You

      Best regards

      Railey Shahril