HOW TO RETURN THE PREVIOUS VALUE IN CRYSTAL REPORT

[Shania Last]

HI ALL,

I HAVE A TABLE IN CRYSTAL REPORT 2013 LIKE THIS :

this table is about sales data for each day, and on the 2rd there were no sales. so the column A is 0 on the date.

and the column of SUM is Running total of column A, and grouping by DATE.

I want ifnull sales on the that, then select previous value like this:

I have created a formula for this column like this:

IF ({SUM}) = 0

THEN ({SUM}) = PREVIOUS({SUM})

And the result is still null.

I dont know what else to do, so that the value not null

 

[kray4660]

There is a previous function in Crystal. Normally I use it do filter out duplicate values.