7 Replies Latest reply on Sep 10, 2018 7:09 AM by Shinichiro Murakami

# Total not displaying the right value

Hello everyone

I am struggling with my total calculation.

I have computed 3 lines, each of which is in itself a weighted value.

I want to computed the total of the 3 lines without further calculation

In the tab SUM OF AVERAGE, I have the following set of data, which are weighted averages defined in a calculated field :

Line 1 -   0,4043

Line 2 -   0,3149

Line 3 -  0,0787

and the total is wrongly set to 0,3333 instead of 0,7979

Anyone has an idea of how I can display the total as being 0,7979 ?

thanks a lot for any help

• ###### 2. Re: Total not displaying the right value

It's too much complicated and unfortunately, your way of using Tableau is too special to be handled in forum.

just one point. Table calc can not reflect the exclusion of "hidden" column.

Thanks,

Shin

• ###### 3. Re: Total not displaying the right value

Hello and thank you for your response.

I am attaching a simpler version with a small set of data

I have a survey with 3 questions. In the end I want to know how satisfied are my customers. I am grouping the responses so that I can distinguish whoever is satisfied depending on each of the 3 questions. I attach a weight to each question, so I can compute an overall average satisfaction in one single number. In my example below I want to find 81.13.

I am struggling with the computation of the weighted product on the one end, and then with the sum of the result.

• ###### 4. Re: Total not displaying the right value

Hello,

Then format number as needed.

Thanks, Don

1 of 1 people found this helpful
• ###### 5. Re: Total not displaying the right value

Table calc s always very complicate, but focusing on briging your expected value, here is the approach

if this helped, please mark my answer as correct / helped to close the thread, not from inbox but from original post.

Thanks,

Shin

1 of 1 people found this helpful
• ###### 6. Re: Total not displaying the right value

Thank you so much for your responses, yes it does help a lot. Not sure I understand though but it works !

• ###### 7. Re: Total not displaying the right value

HI Stphane

Table calc is on of the most complicated function in Tableau.

Hope you learn step by step to accomplish your needs.

Thanks,

Shin