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

# Fixed Calculation for Multiple dimensions and 2 measures not working

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

• ###### 1. Re: Fixed Calculation for Multiple dimensions and 2 measures not working

Hi,

Share some sample mock up in a packaged workbook. It will help us to validate the logic which you have mentioned.

Mahfooj

• ###### 2. Re: Fixed Calculation for Multiple dimensions and 2 measures not working

Dear Mahfooj,

Thanks a lot for your quick response.

As requested I have attached the tableau workbook. Please do check.

My Requirement but Numbers showing wrongly - 1st chart is my requirement but numbers were showing wrongly

Wrong numbers split  - 2nd chart is my requirement in cross tab but numbers are wrong

Correct numbers - 3rd chart is the correct numbers so i want same numbers should come in both 1st & 2nd chart