Skip to Content
0
Former Member
Feb 13, 2012 at 11:11 AM

problem regarding crystal report formula if condition

23 Views

Dear Sir,

i am facing a problem in crystal report formula in which i has to use if condition and perform add and subtract

in a row the design is describe under

_*in qnty_           _production_           _out qnty_*
 *600                      600                            0*
*1200                     1800                            0*
*0                             1300                        500*
*300                      1600                            0*
*0                           1200                        400*
*400                       1600                            0*

in qnty has to add and outqnty have to subtract

i has used this formula

WhilePrintingRecords;

NUMBERVAR NUM9;

NUMBERVAR NUM8;

if {@detail}=1 then

NUM9:={@openingbalance}

ELSE

if {trialprocedure2;1.InQty}>=0 then

NUM9:= NUM9 +{trialprocedure2;1.InQty}

else

if {trialprocedure2;1.OutQty}>=0 then

NUM9:= NUM9 -{trialprocedure2;1.OutQty}

plz give solution for this problem

Edited by: bhatt45 on Feb 13, 2012 12:12 PM