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.