divide by previous days value

[kamielrajaram]

Good day,

I have a table that consists of descriptions on a daily basis and would like to work out the following

yesterdays figure /todays figure.

Col1, col2,col3

2011/03/01, Rum, 1.659

2011/03/02, Rum, 2.365

2011/03/03, Rum, 1.965

Thank you

Kamiel

[#2 · Accepted solution]

Hi Kamiel,

Try using above function in the chart.

Regards

sravan

[kamielrajaram]

Thank you,

That worked.

[kamielrajaram]

Thank you,

this worked fine until I selected a specific date. I do not get any value.

[#5]

Hi Kamiel,

It is anyway clear if you are selecting one day from two days used in the formula that it does not work. Use Setananalysis to get the answer even after selection of a date. Try in search you get a lot of examples..

Regards

Sravan