Looks right to me. I would double check to make sure the text matches exactly. Check your spacing, and make sure there are not any return characters in the text anywhere on either side.
No, but have you clicked inside your variables in the data viewer to check and make sure there aren't any errant spaces or returns?
text strings require explicit matches to return a boolean yes to a calc. Alternatively you could use something like:
PatternCount($x_drawing_type; "Hardware") > 0 and $x_drawing_subtype = "Mechanical"
You may also try to strip spaces and special characters out of your strings to match them.
thanks I will check that
I just realized that there isn't a need to check for both things simultaneously. There is never going to be an instance where subtype iisn't always preceded by type "Flight (F)". So all I really need to check is the subtype.
Thanks though, these suggestions will come in handy down the road I'm sure.
by the way, it was a space at the end of "Mechanical". That value is selected from a Value List, and the value list contained a space at the end.