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.