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

    Use Calculated field to change dimension field value on condition


      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'



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


      How do i go about doing what i want then?