Skip to Content
0
Apr 07, 2016 at 08:08 PM

String - Formula

27 Views

Hello,

I have a field which is a string variable here.

I need to eliminate the word Slow in my display here, also to throw into the mix there are blanks/null values here also.

I have tried record expert to <> "Slow" but then it will also not display the null values here.

So I am in Formula Workshop and I trying to build some there here.

Here is what I have, but it's not working:

if IsNull({V_INV_MSTR.HAZARDOUS_MATL_CODE}) or ({V_INV_MSTR.HAZARDOUS_MATL_CODE} <> "SLOW") then

{V_INV_MSTR.HAZARDOUS_MATL_CODE}

else

{V_INV_MSTR.HAZARDOUS_MATL_CODE}

With this code it's still showing the SLOW word and I don't need it.

Any help would be appreciated.

Thank you,
Gerald