-
1. Re: Very new to Calculated fields and struggling!!!
Russell Christopher Jun 8, 2012 5:55 AM (in response to jo.cheaney)Hey Jo!
Create a calculated field on SubscriberTypeID which "looks for" those two values (Right-click the field name, choose Create Calculated Field).
For example:
CONTAINS([Product Name], "Hoo") OR CONTAINS([Product Name], "Hee")
This sucker looks for the string "Hoo" or "Hee" inside the [Product Name] field. When you drop this calculated field on your Filters shelf, the dialog will prompt you to choose True or False. You want True, which essentially says "Give me only rows that have a Product Name which contains "Hoo" or "Hee".
Have fun!
-
2. Re: Very new to Calculated fields and struggling!!!
jo.cheaney Jun 8, 2012 6:07 AM (in response to Russell Christopher)Thank you very much. That works nicely.
Its not logical to a beginner though as I was clicking on the Product name first as its the first column and then the CONTAINS as that's the next column.
Oh well, learning fast.