Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

SAP Crystal Report Formula field

hi,

i have problem in Crystal report formula filed ...

For ex-

Current Output-

Sr.NoOPRECQTYCL
10101
22102
32011

Actual Output-

Sr.NoOPRECQtyCL
10101
21102
32011

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 !!!!!

Tags:
Former Member
Not what you were looking for? View more on this topic or Ask a question