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
