How Show Delta Data ( Difference in dates)

[#1]

HI Experts,

I am fetching Data from Oracle Server,there is one table which have cumulative data date wise,but i have to show actual data on chart.[:'(]

Like..

Data Stores Like this.

sales As On 10-July-2009 = 1000

As On it 11-July-2009 it is = 1050.

As On 12-July-2009 it is = 1110.

And I want to show.

10-July-2009 = 1000

11-July-2009 = 50

12-July-2009 = 60

and so on

I am attaching you my sample application for your review.

Thanks & regards.

Anwar

[prieper]

Hi,

as you are interested in absolute values, makes sense to hardcode the difference in the script.

Tab2: LOAD *, Sales - Peek(Sales) AS Diff RESIDENT Tab1 ORDER BY MyDate;

DROP TABLE Tab1;

When there are more keys, need to include this in the sorting and to add a conditional clause, like

If Field1 = Peek(Field1), Sales ....

HTH

Peter

[#3]

hi,

Thanks 4 reply..but its not showing correct value.please c my data..

[disqr_rm · Accepted solution]

Here you go. See enclosed.

In the expression I have used "fabs" as you want value 84 and not -84 for the second month. "fabs" just make it positive value.

Hope this helps.

[#5]

Gud Man....

[#6]

Hi,

Thanks for your help. How would you skip the first record? (10.006)?

Reason: if I consider getting the first data into my report, daily sales amount will not be presentable in the chart. (Daily sales is around 30, starting value is 10.006)

Thanks again