This content has been marked as final.
Show 7 replies

Re: Aggr function
Gysbert Wassenaar Dec 17, 2012 11:39 AM (in response to Giorgia Michieli)Sum(distinct Ordinato) returns the values I expect but is not logically correct.
Actually, it is logically correct in this case. It calculates exactly what you're asking for. The sum of the distinct values of Ordinato over all the pivot dimensions you wish to consider in calculating the sum. You already found your solution.


Re: Aggr function
Andrea Stecca Dec 20, 2012 4:15 AM (in response to Giorgia Michieli)Can u post new documente with Num.Doc 527?


Re: Aggr function
Gysbert Wassenaar Dec 20, 2012 9:00 AM (in response to Giorgia Michieli)Maybe like this then:
if(Dimensionality()=11,
sum(distinct VEN_QTA_ORD),
sum(aggr(sum(distinct VEN_QTA_ORD), C_COLORE)))

Re: Aggr function
Giorgia Michieli Dec 20, 2012 9:19 AM (in response to Gysbert Wassenaar )Works!! Thank you so much!


Re: Aggr function
Celambarasan Adhimulam Dec 20, 2012 9:11 AM (in response to Giorgia Michieli)Try this
if(RowNo() <> 0, sum( VEN_QTA_ORD), Sum(DISTINCT VEN_QTA_ORD))
hope it helps


