Previous value and current value in stright table.

[hariprasadqv]

Hi All,

I have scenario in which i have to calculate % of current value to the previous value in a stright table. Expecting last coulmn result in the below table.

Value1	Dim	-8000	0.0
Value2	Dim	-5000	0.6
Value3	Dim	-3000	0.6
Value4	Dim	-1059	0.4
Value5	Dim	-1000	0.9
Value6	Dim	5000	-5.0
Value7	Dim	15059	3.0
Value8	Dim	15864	1.1
Value9	Dim	26136	1.6
Value10	Dim	81000	3.1
Value11	Dim	125000	1.5

Expression Plzzzzz. I tried with above(below(coulmn(2)/coulmn(2))) which

Thanks in Advance!!!

[Anonymous]

You are talking about Current Year Value & Previous Year Value??

Pls Share the sample data, else you can write a expression to calculate %

Say: Current Year Data Expression/Previous Year Data Expression and then in number format, change the format

of this expression into Percent(%).

Hope this will help...

[#3]

Hi,

In the above table can you tell me which is the current value and which is the previous value.

[manojkulkarni]

CurrentExp/(Above(CurrentExp)-1

CurrentExp = is you expression for column(2)

[jonathandienst]

I think you just need

=Column(2) / Above(Column(2))

In the Properties | Numbers tab, select % format

[SreeniJD]

Hari,

Can you pls give me more clarity on this request

Sreeni