4 Replies Latest reply: Nov 11, 2016 1:38 AM by Jonathan Dienst RSS

    Variables and if statements

    Casey Johnson

      Having difficulty with using variables in IF statements (being used as measures). Trying to use these expressions in a straight table. The variables themselves work fine in the tables, but trying to use them in conjunction with the IF statements are not working? Can't figure out why they won't work ... usually get back (zero) or a blank field. Any help is appreciated.

       

      Example:

      vExample = Sum(sales)

       

      if ( parts_age <= 90, $(vExample) )  ----- Does not seem to work?

      if ( parts_age = 90, $(vExample) )  ----- Does seem to work ???

       

      Is there an issue with using relational operators in IF statements????