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

      =>AMOUNT

       

      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

       

      Björn