APEX -- Number / Date Format - need percent sign

Hi,
What is the syntax to put in the "Number / Date Format" field of a column definition for an APEX report to add the % sign?
Need the column to remain a number for filtering but to have the display show the % sign??
LVL 2
BILL CarlisleAPEX DeveloperAsked:
Who is Participating?
 
sdstuberCommented:
would it be acceptable to have a single character column following your numeric column that consisted of only the '%' character?
0
 
gatorvipCommented:
Just add '%' in your select:

select <your_number> || '%'
0
 
sdstuberCommented:
I don't think you can have the report column be both a number and have a % on it.

However, you can simply convert your numbers to strings and append '%' to them as shown above
The interactive report filters will still work on the numeric portion

0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
BILL CarlisleAPEX DeveloperAuthor Commented:

"I don't think you can have the report column be both a number and have a % on it."
This is what we encountered and we never was able to have both.

The filters worked as a string to a point but not with the other functions that absolutely need the column to be a number.

We still don't have a percent sign on this column. I thought for sure there was a format that would have been available but guess not.

Thanks for your help Sean,
Bill
0
 
gatorvipCommented:
>>The filters worked as a string to a point but not with the other functions that absolutely need the column to be a number.

What does this mean?
0
 
BILL CarlisleAPEX DeveloperAuthor Commented:
gatorvip... when I concatenated the percent sign it transformed my column to a string as it saved in the APEX UI. The when APEX is run the user can filter using the builtin Actions dropdown in the IR - Interactive Report which sees the column only as a string. The user would have to remove the % and use to_number to create a custom field but then its ugly and our normal user doesn't realize all that...

sean... as another column works but is "over there" a bit so we are just going to use the % in the Column header..

Thanks for the help. Bill
0
 
sdstuberCommented:
I know this is closed, but one last thought.

Might not be appropriate to your needs depending on what you're doing

Could you have 2 columns? One a string with % that is displayed and one numeric that is hidden?

Your user can use the string version, other functions within your page could reference the hidden value.
0
 
BILL CarlisleAPEX DeveloperAuthor Commented:
Yes, that could do it.. I'll try it.. thats right the hidden are also available for the "Actions"

Thanks Sean!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.