'Exago BI - Cannot reference a cell with an aggregation while referencing cell is part of an aggregation

I am using an AGGCOUNT function. This returns a the number for each unique combination of values, so some rows return 1, 2, etc for a grand total of 17, with 13 unique rows.

At the bottom of my report, I tried using a DATAROWCOUNT() function to return 17 to give me the grand total from the AGGCOUNT function, but it only returns 13. When I try to sum all of the values from the AGGCOUNT function using another AGGCOUNT function, I get the below error message:

exago bi cannot reference a cell with an aggregation while referencing cell is part of an aggregation

Any suggestions?



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source