6 Replies Latest reply on Jan 13, 2014 8:40 AM by Michel Caissie

    Syntax to set dimension value based on paramater value

    Kurt Heisler

      I have a parameter called, Select Food Category, with values for Fruit, Vegetable, and Other.

       

      I would like to create a calculated field with this kind of logic:

       

      IF [Select Food Category] = "Fruit"

      THEN [Food Name] = "Apple"

      END

       

      (Food Name is a dimension.)

       

      I'm getting the error, cannot use boolean type in IF expression.

       

      Any suggestions?