2 Replies Latest reply: May 15, 2014 10:13 AM by a2z143 _ RSS

    New Calculated Field Help

    a2z143 _

      Need your help.

       

      I would like to pick up amount of  "F" code and place in CS1 and amounts of "I and E" codes to CS2. 

       

      CS1         CS2         C1   Amount1   C2   Amount2

      0000000   0000000   F     0001500    I     0002500

      0000000   0000000   E     0001000          0000500

      0000000   0000000   F     0020000    I     0001000

      0000000   0000000   E     0003000          0000000

       

      Expected results:

       

      CS1         CS2         C1   Amount1   C2   Amount2

      0001500   0002500   F     0001500    I     0002500

      0000000   0001000   E     0001000          0000500

      0020000   0001000   F     0020000    I     0001000

      0003000   0000000   E     0003000          0000000

       

       

       

      Thanks...