4 Replies Latest reply: Dec 18, 2017 11:08 AM by David Ambrozie RSS

    How to use if condition inside sum(i.e nested sum)

    Pooja Goswami

      Hello,

      I want to sum the output of this entire expression i.e

       

      if(sum(if(aggr(Count({$<[Customer Name]={'ABC'},Sector={'XYZ'}>}[Emp ID]),[Customer Name],Sector)>0,1,0))>3,1,0)

       

      Use the above expression inside sum() function.

       

       

      Kindly help.