3 Replies Latest reply: Jan 22, 2016 10:50 AM by Florent Lelarge-Otiniano RSS

    error variation by year

    Silvia Assuncao

      Hi,

      I Have a problem when calculating variation between years.

       

      I have 3 charts, Chart 1 and 2 the values are correct, but the chart 3 does not bring right values (value for chart 3 should be the same as chart 2.

       

       

      Expression for Chart 2

       

      (Sum(if(Year='2015' or Year = '2014' or '2016' ,Actual/1000))
        - (
      Above(Total ((Sum(if(Year='2015' or Year = '2014' or '2016' ,Actual/1000))
      )),
      Count(DISTINCT Total<Year> [Year]))))
       

       

      This is teh expression I'm using: and the result is not right.

       

      (Sum(if(Year='2015' or Year = '2014' or '2016' ,Actual/1000))
        - (
      Above(Total ((Sum(if(Year='2015' or Year = '2014' or '2016' ,Actual/1000))
      )),
      Count(DISTINCT Total<Year> [Company Code]))))

       

       

       

      Could you please help me with this?

      best regards,