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



      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 )