SAP Crystal Report Formula field

[Former Member]

hi,

i have problem in Crystal report formula filed ...

For ex-

Current Output-

Sr.No	OP	REC	QTY	CL
1	0	1	0	1
2	2	1	0	2
3	2	0	1	1

Actual Output-

Sr.No	OP	REC	Qty	CL
1	0	1	0	1
2	1	1	0	2
3	2	0	1	1

here i used OP as formula field i required if OP is zero then last CL is = REC , next row if REC is not then previous CL is 2nd row OP value.

i use following formula -

shared numbervar openingbalance;

shared numbervar openingbalance2;

shared numbervar x;

shared numbervar RecQty;

whileprintingrecords;

x:=x+1;

if(x=1) then

(

OP:={REC} - {QTY};

0;

)

else if(x>1) then

(

OP:= OP+ (REC ) - (QTY);

OP;

)

please give me any solution as soon as possible ....

please rly fast

Thanks !!!!!

[abhilash_kumar]

Hi Kiran,

Please elaborate:

here i used OP as formula field i required if OP is zero then last CL is = REC , next row if REC is not then previous CL is 2nd row OP value.

-Abhilash