1 Reply Latest reply on Aug 13, 2012 1:49 PM by Tracy Rodgers

    Rounding and STR functionality

    Julia Hennelly

      I have a field that I need to be displayed as a percentage or currency or a straight number.  To do this I have added a field to my view determining if a percent sign is needed or dollar sign etc.  I then have the following calculated field purely for display:

       

      if  [percentornot] = 'percent' then str(round([MonthActual],2)) + '%'

      else '$' + str(round([MonthActual],2))

      end

       

      however display is as follows:

       

      Support suggested I upgrade my version of desktop which I did but still no resolution to the rounding dilemma.

       

      Packaged workbook attached.

       

      screenshotrounding.JPG