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 !!