Announcements
cancel
Showing results for
Did you mean:
Creator III

## Aggregated expression

I have a very large table with the following 3 dimensions

and 6 expressions:

 ID Type Set SUM({}NUM) AGGR(NODISTINCT SUM({} ID AGGR(NODISTINCT SUM({} NUM),Type_Set) SUM(TOTAL {} NUM) SUM({}NUM)/AGGR(NODISTINCT SUM({} NUM),ID) AVG(SUM({}NUM)/AGGR(NODISTINCT SUM({} NUM),ID)) 123 A NAERG 33 1794 41073 5544553 0.0184 0.019246154 123 A BZFAW 57 1794 180841 5544553 0.0318 0.019246154 123 A AQEGA 64 1794 152782 5544553 0.0357 0.019246154 123 A HSSMFM 15 1794 27766 5544553 0.0084 0.019246154 387 A AEGGV 10 1729 707 5544553 0.0058 0.019246154 387 A ASDFBT 12 1729 36537 5544553 0.0069 0.019246154 387 A MGFMNS 101 1729 82458 5544553 0.0584 0.019246154 387 A NEATN 33 1729 69241 5544553 0.0191 0.019246154 914 A MGFMNS 30 1751 82458 5544553 0.0171 0.019246154 914 A AETWAQ 35 1751 139096 5544553 0.02 0.019246154 914 A DTUKDTUJ 20 1751 99431 5544553 0.0114 0.019246154 914 A STJN 15 1751 151647 5544553 0.0086 0.019246154 914 A AWEGG 15 1751 7527 5544553 0.0086 0.019246154

My problem is with the final expression. I have displayed in the table the value I would like to see (which is an average of all the values in the 5th column), but the expression doesn't work as it currently is.

Hope this is explained clearly - help would be much appreciated!

1 Solution

Accepted Solutions
MVP

May be try this

Avg(TOTAL Aggr(Sum({<GEN={'ALL'}>}NUM)/Sum(TOTAL <ID> {<GEN={'ALL'}>} NUM), ID, Type, Set))

3 Replies

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
MVP

May be try this

Avg(TOTAL Aggr(Sum({<GEN={'ALL'}>}NUM)/Sum(TOTAL <ID> {<GEN={'ALL'}>} NUM), ID, Type, Set))

Creator III
Author

Thank you Sunny!

Another quick,simple solution

Much appreciated,

Jess

Community Browser