7 Replies Latest reply on Nov 2, 2016 7:48 AM by Joe Oppelt

    How do I use true/false dimensions in a logic calculation?

    Amelia Kohm

      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)


      Screen Shot 2016-10-31 at 2.04.29 PM.png

      I then tried to create a logic calculation as follows (see below_


      Screen Shot 2016-10-31 at 2.04.09 PM.png

      However, the calculation didn't work. I got this message:


      Screen Shot 2016-10-31 at 2.04.55 PM.png


      What did I do wrong? Thanks for your help!