Why is this formual failing?

[Former Member]

HI We are getting this error ..................                    " ) is missing

shared numbervar TotalMin:=TotalMin;

shared numbervar endtime:=0;

shared numbervar CalTime:= CalTime;

if {EMPHISTL1.EMTRNC} in ('REL' 'EBC' 'EBV' 'EBA' 'BOM' 'BOO' 'BSB')

and {EMPHISTL1.EMPDPT} in '422' '2'

then

    TotalMin:= {EMPHISTL1.EMTRT};

//

if {EMPHISTL1.EMTRNC} = 'ECT'

[Former Member · Accepted solution]

Hi,

Try this:

shared numbervar TotalMin:=TotalMin;

shared numbervar endtime:=0;

shared numbervar CalTime:= CalTime;

if {EMPHISTL1.EMTRNC} in ['REL' 'EBC' 'EBV' 'EBA' 'BOM' 'BOO' 'BSB']

and {EMPHISTL1.EMPDPT} in ['422' '2']

remaining same see how this works..

--dj

[Former Member · Accepted solution]

am getting the same error

[Former Member · Accepted solution]

Hi,

try this:

shared numbervar TotalMin:=TotalMin;

shared numbervar endtime:=0;

shared numbervar CalTime:= CalTime;

if ({EMPHISTL1.EMTRNC} in ['REL', 'EBC', 'EBV', 'EBA', 'BOM', 'BOO', 'BSB']

and {EMPHISTL1.EMPDPT} in ['422', '2'])

then

    TotalMin: = {EMPHISTL1.EMTRT};

--dj