4 Replies Latest reply: Sep 18, 2015 5:44 PM by Mark Graham RSS

    Set analysis

    Mark Graham

      Hi all,

       

      I was eager to know whether can we write a set analysis statement for the below If statement:

       

      Aggr(If(Len(Trim(Amount))>0, Amount, Profit), ID).


      I have 3 columns, ID, Amount and profit.

      But for few IDs the "Amount" field is empty and hence i wanna fetch the profit field whenever i encounter a null in "Amount".


      Can someone pls help here.