how to count greater than ,less than

[shasha3006]

hi good people,

i want to asking

how to count greather than ,less than

i want to count,field Sum(gross)/COUNT(DISTINCT target) have value grater than 1500000 less than 2000000

i have script,but didnt work

if(Sum(gross)/COUNT(DISTINCT target)>='1500000<=2000000','2','0') as dua,

thanks

shasha

[Digvijay_Singh]

If possible pl share the full script to understand how are you applying group by in your script.

The statement you shared should be something like this - 

if(Sum(gross)/COUNT(DISTINCT target)>=1500000 AND Sum(gross)/COUNT(DISTINCT target)<= 2000000,'2','0') as dua,

<=2000000','2','0') as dua,