Skip to Content

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

If Statement returns incomplete data


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




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


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


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


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!


Former Member

Helpful Answer

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