Regarding exp Calculation issue?

d_koti24 — Fri, 21 Aug 2015 10:02:05 GMT

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?

Re: Regarding exp Calculation issue?

sunny_talwar — Fri, 21 Aug 2015 10:06:59 GMT

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