Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

If Statement returns incomplete data

Hi,

I have a table workorder with these fields wonum, eqnum, eqnum1 , here is the sample data

wo001,null,null

wo002,FCU-01,null

wo003,null,Urinal

Then I have a formula named Equipment

IF (IsNull ({workorder.eqnum}) AND isnull ({workorder.eqnum1}) OR {workorder.eqnum} = "" AND {workorder.eqnum1} = "" OR

IsNull ({workorder.eqnum}) AND {workorder.eqnum1} = "" OR IsNull ({workorder.eqnum1}) AND {workorder.eqnum} = "" )THEN

"FIXME"

ELSE IF (not isnull ({workorder.eqnum1}) OR {workorder.eqnum1} = "") THEN

{workorder.eqnum1}

ELSE IF (not isnull ({workorder.eqnum}) or {workorder.eqnum} = "") then

{workorder.eqnum}

when I run the report this is what I get on @Equipment

wo001 - FIXME

wo002 -

wo003 - URINAL

on wo002 I'm supposed to get FCU-01 but i do not get anything and I can figure what is wrong, could anybody please help?

Thanks in advance!

Martin

Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question