2 Replies Latest reply on Oct 20, 2018 9:12 PM by David Garcia

Help!!!

For some reason Tableau is not summing correctly my information. I want to calculate the total reject % of the total rejects divided by total count, which in total should give me 7.9% based on a total of 73 rejects out of 924 total. What Tableau is calculating a reject % for each row and then summing close to 234%, instead of calculating the total rejects / the total count. What am I doing wrong? Please help! Here is my data.

 Machine_Name Shift Day Machine_ID Month Product_Code RejectCount TotalCount Year Ironer 1 1st 16 11,325 10 211 3 3 2,018 Ironer 1 1st 16 11,325 10 212 0 0 2,018 Ironer 1 1st 16 11,325 10 212 1 1 2,018 Ironer 1 1st 16 11,325 10 212 -3 9 2,018 Ironer 1 1st 16 11,325 10 212 0 19 2,018 Ironer 1 1st 16 11,325 10 212 -3 20 2,018 Ironer 1 1st 16 11,325 10 212 0 35 2,018 Ironer 1 1st 16 11,325 10 212 -2 49 2,018 Ironer 1 1st 16 11,325 10 212 7 56 2,018 Ironer 1 1st 16 11,325 10 212 8 59 2,018 Ironer 1 1st 16 11,325 10 212 8 89 2,018 Ironer 1 1st 16 11,325 10 212 18 89 2,018 Ironer 1 1st 16 11,325 10 212 15 99 2,018 Ironer 1 1st 16 11,325 10 212 13 129 2,018 Ironer 1 1st 16 11,325 10 212 3 131 2,018 Ironer 1 1st 16 11,325 10 212 5 136 2,018 Ironer 1 2nd 16 11,325 10 212 0 0 2,018 73 924
• 1. Re: Help!!!

Hey David,

If you divide Reject Count / Total Count you get that 234.1%

If you create the following calculation you will get the 7.9% that you're expecting:

Let me know if that works for you

Thanks

• 2. Re: Help!!!

That worked, thanks so much Matt!