3 Replies Latest reply on Sep 24, 2018 8:57 AM by Shinichiro Murakami

# % of Total Diff

Hi,

I try to calculate the difference between % of total for 2 diff month at total level.  I always get 0%.  I attached my package workbook.

Here is the result i would like to see

 for 201709 Count % of Total Delta BRAZIL 114 40.57% 0.01% <== 0.22 + (-1.04) + (-0.16) +1.37 + (-0.38) MEXICO 167 59.43% -0.01% Total 281 100.00% 0.00%

I just put 1 month as an example.  Of course i would like to see the result for other months as well

Thank you,

• ###### 1. Re: % of Total Diff

????

Mathematically, it's always 0, isn't it?

0.01% is a round issue only.

Thanks,

Shin

• ###### 2. Re: % of Total Diff

No Shin.  Let me try to clarify my problem

I exported the data out the tableau work book.  First i calculated the % of total for each month then i used the % of total for 201709 - % of total for 201609 = % of Total Delta

However, at the end i would like to see the result for each country as below

 Count % of Total Delta BRAZIL 114 40.57% 0.01% <== 0.22 + (-1.04) + (-0.16) +1.37 + (-0.38) MEXICO 167 59.43% -0.01% Total 281 100.00% 0.00%

Please let me know if you have any idea how to do it.

Thank you very much

• ###### 3. Re: % of Total Diff

???

What I am saying is 0% is correct and 0.01% is calculated with rounded value.

Thanks,

Shin