1 Reply Latest reply: Jan 16, 2016 10:16 AM by prabhu appu RSS

    If statement for specific count aggregation

      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),
      )