The formula I have below works fine but what I need to try and do is stop it adding the * only if the {SAMPLEPARAM.PA_NAME} = "Methylene Chloride" but works for the rest.
if {METHOD.ME_TYP} ='COFA'
then '* '+{SAMPLEPARAM.PA_NAME}
else if (IsNull ({METHOD.ME_TYP}) or {METHOD.ME_TYP} = ' ')
then {SAMPLEPARAM.PA_NAME}
else {SAMPLEPARAM.PA_NAME}
any ideas?
Aucun commentaire:
Enregistrer un commentaire