4 Replies Latest reply on Mar 4, 2016 5:15 PM by Brent Schebel

    Use Calculated field to change dimension field value on condition

    jenn.ng

      I want to group similar topics together as one single topic.

      Topic is my dimension.

      This is my calculated field function:

       

      if [Topic] = 'finance' OR [Topic] = 'financing'

      Then [Topic] = 'finance'

      END

       

      However i get the error that i cannot use boolean type in If expressions

       

      How do i go about doing what i want then?