If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Query Calculation off a Elist Item Subtotal

Started by fkli222, 12 Feb 2014 01:44:17 PM

Previous topic - Next topic

fkli222

I am trying to do a calculation that is taking me "Employee Name" Subtotal Measure over Standard Hours but getting a nesting error. When I drag it to the same level as the report grand total, the calculation works but off the total report. How do I make it calculate correctly without an error? Any help would be greatly appreciated!

Error: The aggregate dataItem="Total(Employee Name)" referenced by valueSet="8" is not expected to nest measures'.


fkli222

I removed all the totals and then added each calculation/total in one by one
1)   I removed all the Totals and added in my Utilization Calculation – Ran the report and it works
2)   Then I added the Totals line to subtotal all Brands at the Employee Level – Ran the report and it works
3)   Last, I added a Grand total at the bottom and this is where it breaks with the error below     
                      "The aggregate dataItem="Total(Employee Name)" referenced by valueSet="7" is not expected to nest measures'."