3 Replies Latest reply on Mar 31, 2018 4:23 PM by Deepak Rai

    how do i calculate difference between 2 rows from 1 column

    Sowmya Potluri

      Hi,

       

      attached screenshot,

       

       

      i need to create another LOB Called D Non ISE Calculated field:

       

      (where D Non  ISE = D - D ISE )

      eg: D Non ISE ,NN  Should get 175 - Null = 175 ,

      but i am getting null ... not able to take 2 different rows as 1 row..

       

      Can any on help me , is this doable?

       

      Note : i have different LOB (just Filtered) like A,B , C, D , E, D ISE ( Only D and D ISE i Should substract...and create new LOB D Non ISE ,  The remaining LOB Will stay same )