2 Replies Latest reply on Jan 28, 2019 1:52 AM by Prabhu H

    Fixed Calculation for Multiple dimensions and 2 measures not working

    Prabhu H

      Calculation 1 :

       

      Acceptance % Copy

       

      { FIXED [Vendor Name],[Cluster],[Insp. Month],[Year]: SUM([Total Accp.])/SUM([INSP Qty])}

       

       

      Calculation 2 :

       

      Calculation1 (copy) (copy)

       

      { FIXED [Vendor Name],[Cluster],[Insp. Month],[Year] : MAX(IF Float(([ACC % (copy)])*100) >= float(99) THEN '100%'

      ELSEIF (Float(([ACC % (copy)])*100) >= float(91) and Float(([ACC % (copy)])*100) < float(99)) THEN '91~99%'

      ELSEIF (Float(([ACC % (copy)])*100) >= float(81) and Float(([ACC % (copy)])*100) < float(91)) THEN '81~90%'

      ELSEIF (Float(([ACC % (copy)])*100) >= float(71) and Float(([ACC % (copy)])*100) < float(81)) THEN '71~80%'

      ELSEIF (Float(([ACC % (copy)])*100) >= float(61) and Float(([ACC % (copy)])*100) < float(71)) THEN '61~70%'

      ELSEIF (Float(([ACC % (copy)])*100) >= float(51) and Float(([ACC % (copy)])*100) < float(61)) THEN '51~60%'

      ELSE '<50%'

      END)}

       

      If i Use the above calculation not getting right segregation. Actually total vendor count should be 23 instead of that it is giving the 31 count and for example 100 % it should be 2 count and it is giving me the 3 count. Like wise many vendor it is throughing wrong count

       

       

       

       

      Below is the one i should get

       

       

      Regards,

      Prabhu