Confusion on setting up a formula.

[nervous2]

We make paint, which is derived in codes.

I'm creating labels for our boxes which on the label will have a UL approval graphic, problem is only for certain products / chemistry. This chemistry is evident in the code but I am having a hard time running the suppress formula.

Our codes are resemble

EB-0103-S (E=Epoxy / B (black) / 103 formula code / S=Satin Finish
HG-0466-H (H=Hybrid / G= green / 466 formula code / H = high gloss

etc etc

now here is what i had which worked.

not({FMMAST.Formkey} like 'H*')
and
not({FMMAST.Formkey} like 'P*')

in this formula everything except those that started with H or P in the Formula, would be suppressed. (this is what i needed during in the past)

Now our Ul has changed. I need to adjust the formula but I could use some advice.

I need to keep the existing, except those formulas that start with "HS" or "PS" I WANT to suppress, and anything ending in "T" Eg (HA-0170-MT) I also want to suppress.

can anyone here give me some advice, I just can't seem to get it right.


Thank

 

[briangriffin]

You can modify this slightly to use as the suppression criteria, but often in these cases I'll create a separate formula (can't test, so it might need some tweaking):

if left({FMMAST.Formkey},2) in ["HS","PS"] or right({FMMAST.Formkey},1) = "T"
then true
else
if left({FMMAST.Formkey},1) in ["H","P"] then false
else true


Put in in the details section temporarily and you can easily scan to make sure that the ones you want suppressed have a value of true. Then your suppression formula becomes:

{@Suppression} = true

 

[nervous2]

This worked, perfectly. I am very grateful for the help.

Thank You!.