1 Reply Latest reply: Dec 2, 2016 11:19 AM by Sunny Talwar RSS

    calculate a year average

    Björn Ludwig

      Dear all,


      I have a problem to calculate a year average.


      I have four date field:

      => YEAR

      => MONTH

      => DAY



      If I set a filter for example Year = 2016, Month = 11 and Day=28

      I get only the amount for the date 28.11.2016

      At the same time I want to have a year average to my "Year" Filter.

      So that I have two values.

      The first value ist der amount for the date 28.11.2016

      and the second vaule should be the yaer average for 2016.


      Thanks a lot for your help.


      Best regards