11 Replies Latest reply on Aug 11, 2017 12:53 PM by shwetha sarma

# Help with calculation

Hello,

I need help with a complex calculation.

I have category and respective sub-category. In order for me to calculate the sales, I need to multiply its weight (which was assigned by the company) to the number of items told.

For example: If Category = "Paper" then 0.5 * 75 end.

This will give me my answer.

Thanks.

• ###### 1. Re: Help with calculation

H Swetha,

Your question is really unclear except the calculation.

Is this what you are trying to do?

Let em know if you need more help.

• ###### 2. Re: Help with calculation

Hi Shwetha,

I guess Paper is 0.8, not 0.5.

Anyways,

Thanks,

Shin << Ambassador Spotlight Here ! >>

• ###### 3. Re: Help with calculation

Yes, that is exactly what I'm trying to do. But, I want a tableau calculation for it.

Also, I don't have the direct number for No. of Contracts. I have the entire list of contracts. I should do countd(No. of contracts) * (the weight).

• ###### 4. Re: Help with calculation

Hi Swetha,

Please find the attached work book.

Let me know if that satisfies your question. If yes please mark the question answered else get back to me.

Cheers!!

• ###### 5. Re: Help with calculation

I'm  unable to open the workbook. It says "load not complete". Please re-attach it.

Thanks.

• ###### 6. Re: Help with calculation

What version of tableau are you using?

• ###### 7. Re: Help with calculation

I'm using Tableau 10.2. I would like to see (weights) * (countd(No. of contracts))

• ###### 8. Re: Help with calculation

Alright am using tableau 10.3 so thats the reason it is not able to open . Let me create a lower version and send you. can you please be specific what version are you like 10.2.1.

Can you give me the third level of the version?

• ###### 9. Re: Help with calculation

I'm using 2.2.