6 Replies Latest reply on Sep 15, 2018 6:12 AM by Zhouyi Zhang

# percentage displayed wrong in tableau

Hi,

I have the below table where I have to display percentage

Percentage formula - Customer lot/Total *100

Grand total is displayed as 3052  but actual sum ( 2,814 + 148 +59 +55 +29+21+17+8+6+5+2+1+1 ) is 3166

so the percentage is coming wrong.

Iam doing the following LOD function to fix the total across all rows

SUM({Exclude [Error No]: COUNTD([CUSTOMER_LOT])}) that is also displaying 3052 .so iam not able to get the correct percentage.

Please let me know what i wrong and why the grand total is coming wrong.I have attached the worksheet

• ###### 2. Re: percentage displayed wrong in tableau

Hi, Shri

Can't connect to your data, but if you can try the calculation I modified below for total and let me know if it works or not.

Hope this helps

ZZ

• ###### 3. Re: percentage displayed wrong in tableau

HI ZZ,

I applied the LOD expression like below but I got 4650 instead of 3152 .Please let me know how to fix this.

{ FIXED [Plant MFG] : SUM({ FIXED [Plant MFG], [Error No] :COUNTD([CUSTOMER_LOT])} ) }

• ###### 4. Re: percentage displayed wrong in tableau

Hi,

Can someone help.All I need is get the total correct so that i can calculate the %

• ###### 5. Re: percentage displayed wrong in tableau

HI ZZ,

I created extract and then exported as packaged workbook and attached here.Now you should be able to view the data.

Thanks.

• ###### 6. Re: percentage displayed wrong in tableau

Hi, Shri

My bad. I forgot to say when using the fixed lod, if the filter is not part of the calculation, make sure add it to context

workbook attached as well.

Hope this helps

ZZ

1 of 1 people found this helpful