0 Replies Latest reply: Feb 22, 2017 4:53 AM by Henry T RSS

    Strange Bug Year to Year Comparion in Pivot table

    Henry T

      Hi all,


      I have a Pivot table with different amounts. These amounts should be compared to the the same time one year before and show the %-difference.


      I have one strange problem. For the year 2017 it shows me the wrong %-difference. Everything else is correct (i.e. comparing 2016 to 2015). But 2017 to 2016 shows me wrong numbers.




      currently my logic is looking like this


      If(Sum({< Flag = {'2017'}>}FF_FF_FLIGHT_SUM) > 0,

      Sum({< Flag = {'2017'}>}FF_FF_FLIGHT_SUM)


      Sum({< Flag = {'2016'}>}FF_FF_FLIGHT_SUM) - 1)


      Attached is a sample.


      Does anybody know a solution for this strange bug?