8 Replies Latest reply: Mar 24, 2015 10:04 AM by L H RSS

    Percent calculation error

      Hi

       

      I have a string in a bar chart like this:

       

      NUM(100-(if([Level 1 Line]='3658' and P2_skär='X',count (distinct (Machine_Skär)))/9)*100,0)&'%'

       

      There are two records where Level 1 Line is 3658

      One of the records has an X in P2_skär

      In Machine_Skär there is one

       

      I would like my bar to rise to 89% (Machine_Skär/9) but i only get 78%

      It seems that the second record without the X is counted in the equation too.

       

      Can anybody see what fault i make?

       

      Best regards

       

      /Mats