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

    Strange Bug Year to Year Comparion in Pivot table

    Henry Tran

      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.

       

      Capture.JPG

       

      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?