
1. Re: Why are my percentages not calculating correctly?
Bora Beran Feb 8, 2016 3:25 PM (in response to Daniel Katz)If Total is a row level calculation e.g. reference to a column in your data and you're using the calculated field as an aggregate e.g. SUM(IIF([Total] !=0, [Total]/[Total],0)) what it will do is to first compute total/total which is 1. then sum up those 1s hence giving your more than 100%.
If you aggregate upfront e.g.
SUM(IIF(SUM([Total]) !=0, SUM([Total])/SUM([Total]),0))
then you should get 100% as expected.

2. Re: Why are my percentages not calculating correctly?
Daniel Katz Feb 8, 2016 4:09 PM (in response to Bora Beran)This worked. Thank you
From: Bora Beran
Sent: Monday, February 08, 2016 6:26 PM
To: Daniel Katz <dkatz@repequity.com>
Subject: Re:  Why are my percentages not calculating correctly?
Tableau Support Community
<https://community.tableau.com/?et=watches.email.thread>
Why are my percentages not calculating correctly?
reply from Bora Beran
<https://community.tableau.com/people/bora.beran?et=watches.email.thread>
in Forums  View the full discussion
<https://community.tableau.com/message/461077?et=watches.email.thread#461077>