Regarding exp Calculation issue?

[d_koti24]

Hi All,

I have stright table.that table contains 4 dim,and 3 exp.

my req is :

id	period	fid	desc	e1	e2	e3
4_19	4/2/2015	fp1	abas	0	5	10
4_19	4/3/2015	fp1	afdf	3	2	15
4_19	4/4/2015	fp1	afdfdf	5	5	25
4_19	4/5/2015	fp2	adsdad	10	-5	35
4_19	4/6/2015	fp2	afa	-5	5	35
4_19	4/7/2015	fp2	asd	10	10	55

i want to add another exp e4:

that is the check sum of e1,e2,above e3

for example if i take  take 2 row :e1=3,e2=2,e3(above(e3))=10  now e4=15

                                      3 row:5+5+15=25

                                      4 row:10-5+25=35

id	period	fid	desc	e1	e2	e3	e4
4_19	4/2/2015	fp1	abas	0	5	10
4_19	4/3/2015	fp1	afdf	3	2	15	15
4_19	4/4/2015	fp1	afdfdf	5	5	25	25
4_19	4/5/2015	fp2	adsdad	10	-5	35	35
4_19	4/6/2015	fp2	afa	-5	5	35	35
4_19	4/7/2015	fp2	asd	10	10	55	55

how to achieve this?

[sunny_talwar]

May be this:

(assuming e1, e2 and e3 are your expression labels)

=e1+e2+Above(e3)

where e1, e2 and e3 should turn blue because they are expression label we are referring to.

Best,

Sunny