5 Replies Latest reply: Jan 7, 2013 3:05 AM by Effendi Gunawan RSS

    aggr function with rangesum(before()) not working

      Dear all,

       

      anyone can help me why this function doesn't return any value?

       

      exp :

       

      sum(

          Aggr(

              if(RangeSum(Before(if(sum(SALES_VALUE_GROSS)>0,1),0,3))=3,1)

              ,CUSTOMER_ID

          )

      )

       

      thanks