
1. Re: Percent calculation from a group
Tracy Rodgers Jun 5, 2012 4:26 PM (in response to Allison Suarez)Hi Allison,
This can be done by creating a calculation similar to the following:
lookup(sum([Order Quantity]), first())/lookup(sum([Order Quantity]), first()+1)
Place the calculation on the view. Then, right click on it and select Compute Using>Pane (Down).
Hope this helps!
Tracy

2. Re: Percent calculation from a group
Allison Suarez Jun 5, 2012 5:23 PM (in response to Tracy Rodgers)Unfortunately that is not working. It is giving me a bunch of 0's and 1's.
It should be as simple as
countd([Problem Type] = 'Other') / countd ([Problem Type] = 'NonOther') but that just gives me 1's.
I'm so confused . . .

3. Re: Percent calculation from a group
Tracy Rodgers Jun 6, 2012 8:23 AM (in response to Allison Suarez)1 of 1 people found this helpfulHi Allison,
My guess is that you need to change the number format of the calculation so that it shows up as a decimal or percentage. Right click on the calculation in the data box and select Field Properties>Number Format>Percentage. Hopefully this will give you the desired results!
Tracy