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

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 )

• ###### 1. Re: how do i calculate difference between 2 rows from 1 column

Zn(D)-ZN(DISE)

• ###### 2. Re: how do i calculate difference between 2 rows from 1 column

they are not separate columns... D and DISE are from same line of business..

my calculations are

// D

if (lob)= 'D' Then 'data' else end

//DISE

if (lob)= 'DISE' Then 'data' else end

//DNon-ISE

D-DISE

• ###### 3. Re: how do i calculate difference between 2 rows from 1 column

pl attach some workbook