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

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 Column Colmun with formula 7000 0 7689 7000 9457 7689 8472 9457 2364 8472 12395 2364 18273 12395 84723 18273 57483 84723 493837 57483 2823747234 493837 226374 2823747234 7646363 226374 85826263 7646363 75756236324 85826263 1239534

75756236324

Message was edited by: Ludek Uher