Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a very large table with the following 3 dimensions
and 6 expressions:
ID | Type | Set | SUM({<GEN={'ALL'}>}NUM) | AGGR(NODISTINCT SUM({<GEN={'ALL'}>} ID | AGGR(NODISTINCT SUM({<GEN={'ALL'}>} NUM),Type_Set) | SUM(TOTAL {<GEN={'ALL'}>} NUM) | SUM({<GEN={'ALL'}>}NUM)/AGGR(NODISTINCT SUM({<GEN={'ALL'}>} NUM),ID) | AVG(SUM({<GEN={'ALL'}>}NUM)/AGGR(NODISTINCT SUM({<GEN={'ALL'}>} 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!
May be try this
Avg(TOTAL Aggr(Sum({<GEN={'ALL'}>}NUM)/Sum(TOTAL <ID> {<GEN={'ALL'}>} NUM), ID, Type, Set))
Kindly Share your application.
Regards,
Kaushik Solanki
May be try this
Avg(TOTAL Aggr(Sum({<GEN={'ALL'}>}NUM)/Sum(TOTAL <ID> {<GEN={'ALL'}>} NUM), ID, Type, Set))
Thank you Sunny!
Another quick,simple solution
Much appreciated,
Jess