Skip to Content
avatar image
Former Member

SAP Crystal Report Formula field

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 23, 2015 at 11:12 AM

    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

    Add comment
    10|10000 characters needed characters exceeded