Boolean Required Here 1

[Shannon2008]

//the formula below gives me an error of 'A Boolean is required here' on the last line following ELSE.
//What did I do wrong?
//I want the formula to return the value of (PRTIME.PAY_SUM_GRP} provided the other conditions do not exist.
//I tried two different ways of writing this, but keep getting the error. The second formula is scaled down.


#1

local stringVar Array Prov_Worked;

IF {PRTIME.WC_STATE}=Prov_Worked THEN {PRTIME.PAY_SUM_GRP}<>'LOU'+
IF {PRTIME.WC_STATE}='BC'THEN {PRTIME.PAY_SUM_GRP}<>'BTC'+
IF {PRTIME.WC_STATE}='NB' THEN {PRTIME.PAY_SUM_GRP}<>'CAR'
ELSE IF ({PRTIME.WORK_STATE})<>Prov_Worked THEN {PRTIME.PAY_SUM_GRP}

#2

local StringVar Array Prov_Worked;

IF {PRTIME.PAY_SUM_GRP}='LOU'
THEN IF {PRTIME.WC_STATE}=Prov_Worked
THEN {PRTIME.PAY_SUM_GRP} = '0'
ELSE IF (({PRTIME.WC_STATE})<>Prov_Worked) THEN ({PRTIME.PAY_SUM_GRP})

 

[IanWaterman]

I think you have over done the brackets

Try

ELSE IF (({PRTIME.WC_STATE})<>Prov_Worked THEN {PRTIME.PAY_SUM_GRP})

YOu had
) THEN (

Which I think is confusing your if statement.

Ian

 

[Shannon2008]

//Thanks but now I get another error
//it wants a ) on THEN
//the error is 'The ) is missing'
//any idea?


local StringVar Array Prov_Worked;

IF {PRTIME.PAY_SUM_GRP}='LOU'
THEN IF {PRTIME.WC_STATE}=Prov_Worked
THEN {PRTIME.PAY_SUM_GRP} = '0'
ELSE IF (({PRTIME.WC_STATE})<>Prov_Worked THEN {PRTIME.PAY_SUM_GRP})

 

[lbass]

IF {PRTIME.PAY_SUM_GRP} = 'LOU' and
{PRTIME.WC_STATE} = 'Prov_Worked' THEN
'0' else
IF {PRTIME.WC_STATE} <> 'Prov_Worked' THEN {PRTIME.PAY_SUM_GRP}

Don't know what you want to do with this case though:

{PRTIME.PAY_SUM_GRP} <> 'LOU' and
{PRTIME.WC_STATE} = 'Prov_Worked'

-LB

 

[Shannon2008]

Thanks LB that worked great!