Formula going wrong

[AdamField]

Hey Guys,

Got a formula that is working in the simple form but the moment i expand it, it start's do go wrong

This is what i have

DB1 Backorkl
: colums with info im using b_afwerk (boolean)
b_relnum

DB2 bomatch
: colums with info i'm using b_type
b_aantal
b_relnum

DB1 and 2 are linked with the relnum field


when i use formula
IF {backorkl.b_afwerk} = true THEN "NVT"
ELSE "OK"
it works in my report
when i expand the formula to

IF {backorkl.b_afwerk} = true THEN "NVT"
ELSE IF {bomatch.b_type} = 1 THEN
IF totext({?aantal}) = totext({bomatch.b_aantal},0,"")
THEN "OK"
ELSE totext({bomatch.b_aantal},0,"")

it stops giving me "NVT" values but the second part works (i get or the OK or the bomatch.b_aantal)

It looks like the formula ignores the b_afwerk test
the 2 DB's are linked with a inner join if that may help

Tnx for the help in advance !!

 

[AdamField]

hey again,

got the problem solved by somebody on CR forums and it was only a mather of placing the correct () arround the if then elses....