2 Replies Latest reply: Jul 19, 2017 8:36 AM by Pradeep Vanguri RSS

    my below if condition is valid but doesn't give accurate answer?

    Divyanshi Bansal

      if(Aggr(Sum(Revenue),[Customer Group Descr])<1,'Tail_Account',

      if(Aggr(Sum(Revenue),[Customer Group Descr])>=5,'Large_Account',

      if(Aggr(Sum(Revenue),[Customer Group Descr])>=1,

      if(Aggr(Sum(Revenue),[Customer Group Descr])<5,'Middle_Account'),'0')))

       

       

       

       

      Can anyone tell Why is it so ?