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.