5 Replies Latest reply on Aug 14, 2018 10:14 AM by Sara Stark

    Calculations: > & < comparisons not working correctly

    Sara Stark

      I have a dimension field containing a factor. I created a calculated field that essentially buckets those factors into groups. However, I'm finding that some factors aren't ending up with the correct group value assigned. Any ideas what I need to do differently?

       

      Example: I want the factor of 0.9 to be assigned a value of "-5.1% to -10%", but it ends up with a value of "-10.1% to -15%":

       

      Thanks!
      Sara