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"



      (Food Name is a dimension.)


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


      Any suggestions?