🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

Need to display field value in two different formats

User: "mark_s_vangee"
mark_s_vangee
Altair Community Member
Updated by Jocelyn

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!

Find more posts tagged with

Monarch
Sort by:
1 - 1 of 11
    User: "CPorthouse"
    CPorthouse
    Altair Employee

    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.

Quick Links