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



      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.