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

    Percent calculation error



      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