8 Replies Latest reply on Aug 4, 2016 2:33 AM by Akhilesh Singh

# Percentage Calculation is Wrong

Hi,

I am trying to get percentage of a column. But, it always divide from the aggregate number of total.

Please help.

Regards,

Akhilesh Singh

• ###### 1. Re: Percentage Calculation is Wrong

Hello Akhilesh,

Is there any way you can create an example of your problem using the superstore data that comes with tableau? It will be much easier to help you if we can see what the problem is.  Please try that and save the workbook as a packaged workbook (.twbx) then attach to this thread.

Many thanks

Steve

• ###### 2. Re: Percentage Calculation is Wrong

Hi Akhilesh,

Can you share the scenario (no data, no workbook required) a bit? This can be surely solved.

In case you want the % by any particular dimension then LOD can be used.

-Ashish

• ###### 3. Re: Percentage Calculation is Wrong

Hi,

Thank you for reply. I have attached the viz. Please have a look.

• ###### 4. Re: Percentage Calculation is Wrong

Hi Akhilesh

What are you hoping to see from the [Abs.% Error x (A)(3) x (6)] field?

You have set it to calculate like so:

Which multiplies the [Abs. %Error(ABS(A-F)/A)x100(6)] field (currently valued at 30 * not 30% because you've multiplied by 100 in it's calculation) by your total shipment field.

Are you looking to dis-aggregate the SUM(shipment)? or multiply by the [Abs. %Error(ABS(A-F)/A)x100(6)] field as a %?

Steve

• ###### 5. Re: Percentage Calculation is Wrong

Hi Akhilesh,

I am actually wondering how did you arrive at 503407900.

-Ashish

• ###### 6. Re: Percentage Calculation is Wrong

Hello Steve,

Yes I wanted to multiply the shipment. But, as getting aggregation error. I took Sum(Shipment). If you have any other better way to do this. Please help.

• ###### 7. Re: Percentage Calculation is Wrong

Hello Ashish,

This is the actual number which we should get after all calculations. When you change Default property to sum. It will give you the number.

-Akhilesh

• ###### 8. Re: Percentage Calculation is Wrong

Hello,

I also want % of these fields ([ErrorA-F(4)]/[Shipment])*100 but it is giving me 1600 value. not the %.