Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I´m having a problem with The aggr Function. Í am building an object with a calculated dimension ex: IF (CUST_SALES<'0' , CUST). Now I´m trying to build an object to filter the first one, in this filter i have to use an aggr function, and i want to use the function over the expression above instead of the field, more or less this way:
AGGR ( EXPRESSION , (IF (CUST_SALES<'0' , CUST)) )
Thnk you Guys
Hi,
I'm not sure if I understood you correctly, but you could try this:
AGGR ( if( CUST_SALES<0, EXPRESSION) ,CUST )
If it doesn't work, please share a data sample and we can try it on a qvw
Hope it helps,
Erich
Hi,
I'm not sure if I understood you correctly, but you could try this:
AGGR ( if( CUST_SALES<0, EXPRESSION) ,CUST )
If it doesn't work, please share a data sample and we can try it on a qvw
Hope it helps,
Erich
Thanks Erich, it works !!!