4 Replies Latest reply: Sep 24, 2014 6:21 AM by sujeet Singh RSS

    If condition in load

      Hi freiends,


      I have a table like


      A B C D                    E

      1  2 3 sales              Profit

      2 3 4  Commisions     Loss

      6 8 9  Margin            Profit


      Now I have to load based on coumns D and E using resedent load.


      If D= sales and e= Profit then A-B as xxxx

      else if D=Commission and E = Loss as YYY etc