How to find out the Prvious value in a dataitem

[Sarayucog]

Hi All,

I have a list like below.

Sno Revenue  Revenue%

1    100
2    200
3    300
4    400
5    500
6    600

Actually my requirement is (Previous Revenue / Current Revenue). Means

As per the formula EX1: (200/100) = 2
         EX2: (300/200) = 1.5
         EX3: (400/300) = 1.333

Like this we have to find out the Revenue%. For this we have create a data item to hold Previous values. In the example 1 100 is Previous value , in EX2 200 is Previous value and EX3 Previous value is 300.


Thanks in advance

[pricter]

Create two queries and join them id from the one query and by the id minus one from the other one.

So in the third query item that it would be created by the join of the two queries you will have side by side
the current and the previous values so to perform your desire calculation