8 Replies Latest reply on Feb 11, 2014 2:42 AM by L M

    lookup function issue

    L M

      Dears Sirs, I'm a newbie and I was trying Tableau Desktop for a simple calculation, but there is something I don't understand.

      In my example (see table) I have a calculated field '%' which is defined as '[s]/[i]' with number format as percentage with 2 decimal values.

      I have another calculated field 'increment' which is defined as

       

       

      ZN(SUM([%])) / LOOKUP(ZN(SUM([%])), -1) -1

       

       

      , computed using "Pane Down" and with number format as percentage with 2 decimal values.

       

       

      I don't understand how it gets value '4.05':

      9.81 / 9.43 -1 = 0.040296

       

       

      so I should get 4.03.

       

      This is my table:

      si%increment
      221882353399.43%
      230612350869.81%4.05%

       

      Is there anything I don't understand?

      Thanks