If statement for specific count aggregation

Wed, 13 Jan 2016 01:05:51 GMT

I want to test if the count aggregation is <=3. I tried putting <=3 but it didn't work. If count is <=3, sum(3) else no equation. How can I solve this. Thanks for your help.

If($(Tmonths)=10 or $(Tmonths)=11 or $(Tmonths)=12 
and count({<cyear= {$(Tyear)}>} 
aggr(DISTINCT Basic,SEF,qtr,cyear,OwnerNum,BINum,PCINum,SINum,MDINum,Parcel,PType))<=3, 

sum(3),
)

Re: If statement for specific count aggregation

prabhuappu — Sat, 16 Jan 2016 15:16:23 GMT

Hi,

You should use the count function inside the aggr function,

if(aggr(Count(Fields), <Group by Fields>)<=3,Sum(3), ....)

Regards,

Prabhu Appu

topic Re: If statement for specific count aggregation in App Development

If statement for specific count aggregation

Re: If statement for specific count aggregation