5 Replies Latest reply on Aug 1, 2012 9:57 AM by barry.danielson

    How do I format a rounded result displayed as a string in a calculated field?

      I am using the following calculated field in order to facilitate labels with 2 data points included.

      STR(ROUND(AVG([Response]),2))

      +"

      n= "

      + STR(COUNTD([Registration ID]))


      The result is not displaying correctly (2 decimals) for the first data point in the formula. Instead, it is displaying a number like:


      9.3800000000000008

      n= 2275


      How do I need to change the formula so that the result displayed is:

      9.38

      n= 2275


      I need to make the same correction for this calculated field:

      STR(([Count of Yes Records]/[Count of Total Records]*100))

      +"%"

      +"

      "

      +"n= " +STR([Distinct Registration ID Count])


      86.060460653%

      n= 3587


      needs to be:

      86.06%

      n=3587