Value of preceding fields

[Bruni007]

Hi,
Can anyone tell me if there is a way to evaluate preceding fields, not only the one last record with the Previous() function...
I need to know the value of the 4th preceding field by example
How can I do that?

 

[synapsevampire]

You'd need to keep track of it in variables.

whileprintingrecords;
numbervar value v4;
if remainder(recordnumber,2) = 0 then
v4:={table.field}

That would store the value of every 4th row. You can't say go back 4 rows, and I suspect that there's a better way of doing what you need.

I suggest that you put a little more effort into your post:

Crystal version
database/connectivity
Example data
Expected output

-k