Greater than operator with AGGR

[#1]

Hi All,

I am trying to calculate the following expression but it is giving me '0' in the result.

count(DISTINCT(if(aggr(sum(CNT_SF_NPP),PROF_SK,TIME_SK, PROD_SK)>>1,PROF_SK)))

whereas the below formula is giving me the desired result

count(DISTINCT(if(aggr(sum(CNT_SF_NPP),PROF_SK,TIME_SK, PROD_SK)=1,PROF_SK)))

Can't i use '>>' function with if(aggr.... or if I am doing something wrong?

Thanks
Arun

[rubenmarin]

Hi Arun, Greater than operator is '>', not '>>'