Formula error - booleen required

[rico7937]

Can someone take a look at this formula and let me know why I am getting a boolean required on line # 5

If (isnull ({VENDOR_INFO.VEND_FIELD5}))
then
" "
else
({VENDOR_INFO.VEND_FIELD5})
and
({VENDOR_INFO.VEND_FIELD5}) <> "OVERDUE"
and
({VENDOR_INFO.VEND_FIELD5}) <> "OVERDUES"

I know I have null data in this table but when I include the last 2 statements then my null data does not appear, only tickets with data in the field appears.

 

[SkipVought]

[b]
({VENDOR_INFO.VEND_FIELD5})[/b]
and
({VENDOR_INFO.VEND_FIELD5}) <> "OVERDUE"
and
({VENDOR_INFO.VEND_FIELD5}) <> "OVERDUES"

Each of the expressions between the boolean AND operators evaluates to either TRUE or FALSE.

So CR assumes that ]({VENDOR_INFO.VEND_FIELD5}) will also.

So is VENDOR_INFO.VEND_FIELD5 defined as Boolean or not? If not, you need some equality in that expression to generate TRUE or FALSE.


Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[rico7937]

Maybe I'm coding wrong for what I am trying to do:

First I want to pull in all the records from the VENDOR_INFO.VEND_FIELD5

Then I add the 2 statements below:

{VENDOR_INFO.VEND_FIELD1} = "Y"
AND
NOT ({PROBLEM.PROBLEM_ABSTRACT} STARTSWITH ["DR-*","[DR]"])

So far everything is ok, I know have null field data in VENDOR_INFO.VEND_FIELD5 but there are other entried in that field that I do not want in the report. So as soon as I code in the following 2 statements then I get only data that is populated in the field excluding what I am trying not to show, but at the same time any fileds that was null has disappeared from the report.

({VENDOR_INFO.VEND_FIELD5}) <> "OVERDUE"
and
({VENDOR_INFO.VEND_FIELD5}) <> "OVERDUES"

How do I get the null data in ({VENDOR_INFO.VEND_FIELD5}) to remain while excluding the Overdues at the same time ?

 

[lbass]

{VENDOR_INFO.VEND_FIELD1} = "Y" AND
NOT ({PROBLEM.PROBLEM_ABSTRACT} STARTSWITH ["DR-*","[DR]"]) and
(
isnull({VENDOR_INFO.VEND_FIELD5}) or
not({VENDOR_INFO.VEND_FIELD5} in ["OVERDUE","OVERDUES"])
)

-LB

 

[rico7937]

Thank you ! That worked as expected !