Need to display field value in two different formats

mark_s_vangee

I have a field in a report that sometimes has the value displayed as a number, and other times it is displayed as a percentage :

1191

380

120

4.90%

Is there a way to show the values in this column in the same field in the two different formats?

Thanks for any help!

CPorthouse

I think the only way you can achieve this is to convert the field to a "character" data type. If you are going to need to do any numeric calculation on this field, I would have one numeric field (choosing whatever format you like) and a character field. You can always hide the numeric one if you do not want to see it.