
1. Re: Percentage Calculation is Wrong
Steve Taylor Aug 4, 2016 12:24 AM (in response to Akhilesh Singh)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
Ashish Chaudhari Aug 4, 2016 12:25 AM (in response to Akhilesh Singh)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
Akhilesh Singh Aug 4, 2016 1:43 AM (in response to Steve Taylor)
Sample Data.twbx 59.1 KB


4. Re: Percentage Calculation is Wrong
Steve Taylor Aug 4, 2016 1:56 AM (in response to Akhilesh Singh)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(AF)/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 disaggregate the SUM(shipment)? or multiply by the [Abs. %Error(ABS(AF)/A)x100(6)] field as a %?
Steve

5. Re: Percentage Calculation is Wrong
Ashish Chaudhari Aug 4, 2016 1:58 AM (in response to Akhilesh Singh)Hi Akhilesh,
I am actually wondering how did you arrive at 503407900.
Ashish

6. Re: Percentage Calculation is Wrong
Akhilesh Singh Aug 4, 2016 2:05 AM (in response to Steve Taylor)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
Akhilesh Singh Aug 4, 2016 2:05 AM (in response to Ashish Chaudhari)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
Akhilesh Singh Aug 4, 2016 2:33 AM (in response to Akhilesh Singh)Hello,
I also want % of these fields ([ErrorAF(4)]/[Shipment])*100 but it is giving me 1600 value. not the %.