Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Aggregating over percentage values... Totals do not add up
Migrateduser
<div>How do you aggregate over the percentage values that are themselves result of a group aggregation? </div>
<div> </div>
<div>As an example, I prepared an .rptdesign file that relies on the Classic Cars datasource. I am also including a screenshot of the output. </div>
<div>As you can see, the aggregation over the actual dollar amounts (col #2) is good and correct. But when I use the similar aggregation to add my percentages in col #3, then I get 345% as a result. Clearly, it should add up to 100%. </div>
<div> </div>
<div>Any ideas how to to SUM over the aggregated percent values? </div>
<div> </div>
<div>Thanks,</div>
Find more posts tagged with
Comments
There are no comments yet