9 Replies Latest reply: May 30, 2016 5:23 AM by laxman V RSS

    frequency distribution  - calculated fields

    Mariano Candau

       

      Hello friends,

       

      I have a field with numbers from 0 to 100 with 2 decimal places. I'm trying to create a calculated field where convert those numbers into 5 ranks. The expression may be (integer ("value" / 20)) * 10.

       

      With this field I'll do a frequency distribution graph.

       

      The problem is that there i'snt a function "integer" or "mod" on Sense for calculated fields.

       

      Any idea?

       

      Thanks in advance !!