Can I use AGGR function with an exppresion instead of a field ?

[#1]

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

[erichshiino · Accepted solution]

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

[#3]

Thanks Erich, it works !!!