I want to create a dimension called school location which has the value "Barton" if the value of a dimension called servicename includes the word "Barton" and has the value of "Joplin" if the value of servicename includes the word "Joplin" etc.
I created calculated fields for each school location as follows (see Barton example below)
I then tried to create a logic calculation as follows (see below_
However, the calculation didn't work. I got this message:
What did I do wrong? Thanks for your help!
Hey Amelia,
I don't know if you've tried this method yet, but it appears that you are taking this as a two step process when you can simplify it to a one step with the below calculation.
IF CONTAINS([servicename], 'Barton') THEN 'Barton'
ELSEIF CONTAINS([servicename], 'Joplin') THEN 'Joplin'
ELSEIF CONTAINS([servicename], 'Ogsleby') THEN 'Ogsleby'
ELSEIF CONTAINS([servicename], 'Westcott') THEN 'Westcott'
ELSEIF CONTAINS([servicename], 'Perspectives') THEN 'Perspectives'
ELSE 'School Location Unknown'
END
If I understood your use case correctly, the above solution may be able to help you out.
KJ
