5 Replies Latest reply: Dec 6, 2012 10:51 AM by Brian Garside RSS

    Dual returning the Numeric Value when using MIN expression

      I used the dual function to apply numeric value to my ratings, but when I use the MAX function in an expression, I'm getting the numeric value and not the text.

      FYI: My script looked like:

      if(RATING='big',dual(RATING,10),
      if(RATING='med',dual(RATING,5),
      if(RATING='small',dual(RATING,1),
      dual(RATING,0)))) as DualRating

       

      Thanks in advance.