cancel
Showing results for 
Search instead for 
Did you mean: 

Good day sir. Im newbie in using SAP Crystal Report. I hope you can help me with my problem

Former Member
0 Kudos

PROBLEM EXPLANATION

Pretend that the attached excel file is a crystal report file

Column A is the details to be compared. Column B is the details that i will have to use a formula in sap crystal report.

as you can see cell B3 is same with the value in cell A2, B4 with A3, B5 with A4, B6 with A5 and so on.

How can i get the previous data of column A and put it in column B using formula in crystal report? either basic or crystal syntax

My ColumnColmun with formula
70000
76897000
94577689
84729457
23648472
123952364
1827312395
8472318273
5748384723
49383757483
2823747234493837
2263742823747234
7646363226374
858262637646363
7575623632485826263
1239534

75756236324

Message was edited by: Ludek Uher

Accepted Solutions (1)

Accepted Solutions (1)

abhilash_kumar
Active Contributor
0 Kudos

Hi,

Use the 'previous()' function.

Example:

Previous({Column A})

-Abhilash

Former Member
0 Kudos

Thank you very much sir. it helps me a lot

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Try this,

Create a formula

If OnFirstRecord then

0 else

Previous ({ColumnA})