I have one field that contains codes that look like this TTP125987, CDR012, and so on... and another with brands like DELL, IBM, APPLE, etc. and I want a new field with a description based on brand and model BUT if the code has the letters TTP, I don´t want the description to include the brand for that code and place XX instead of the brand and the model, but I can´t get my calculation to work as follows because it always includes the code:
If(SKU_code="TTP"; "XX" ; item_brand) & item_model
What it should show is XX followed by the model if the code includes TTP and if it doesn´t it should include the brand and model.
any ideas ?? thanks in advanced for your help.