4 Replies Latest reply on Feb 22, 2016 6:59 PM by Shinichiro Murakami

# How to calculate %Difference of Measured Values

Hi, folks

I would like to know how to calculate the % Difference of Measured Values. Please see the last row in the table below.

In the last row of Measured Values, I expect to get 2%(5% - 3%) resulting from % difference of Unit Name A and B in On_SeWF.

But I did not get it.

Any helps and related links are appreciated.

Regards,

Shuta

• ###### 1. Re: How to calculate %Difference of Measured Values

Shuta,

It is a little difficult for me to tell exactly what is going on in the workbook from the attached screen shot. If you could provide a sample workbook I would be happy to look into more detail on the issue. But, here is some general information on the use of the %difference equation: http://onlinehelp.tableau.com/current/pro/online/windows/en-us/help.html#calculations_tablecalculations_definebasic_diff…

As well as some definitions of the basic Table calculations we have to offer: http://onlinehelp.tableau.com/current/pro/online/windows/en-us/help.html#calculations_tablecalculations_definebasic.html…

-Regards,

Patrick

1 of 1 people found this helpful
• ###### 2. Re: How to calculate %Difference of Measured Values

Shuta

Table calculation does not support Table calc x Table calc in this case.

So, "% of Total Value along Table (Down)" should be calculated by formula, not table calculation,

Then, that field can be used for "next" table calculation of "Difference from previous:"

[Value % of TTL]  //  % down the pane.

sum([Value])/attr({fixed[Unit Name]:sum([Value])})

Thanks,

Shin

9.0 attached.

2 of 2 people found this helpful
• ###### 3. Re: How to calculate %Difference of Measured Values

Patrik and Shin

Thanks a lot for your replies. Those replies answered to my question and I could finally implement % of difference of the values.

Sincerely,

Shuta

• ###### 4. Re: How to calculate %Difference of Measured Values

Shuta,

Happy to hear so.

Just one more request, could you mark "Correct answer" for other community people to know it's answered.

Thanks,

Shin