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

Helpful Answer

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