Attribute formatted as text eventhough it's a number...

Anders W. Langholm

Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of):

ØSS-Samarnbejdet (DTU)

Description (Required):

In the subject area "Expenses - Expense Transactions Real Time" the Attribute called "Approval Level" seems to be imported in text-format, even though it is a number... So if you want to sort or rank by this attribute. you need to add some functions to it, which seems to give a higher risk of experiencing ODBC-errors...

Use Case and Business Need (Required):

I would like the attribute to be formatted as a number, to be able to sort by it, for example when I want to rank the attribute, to get the latest approver, when there are more than one approver in the report.

Image description

I'm trying to solve the problem by using a cast-function, but it seems unnecesarry to have to do any number-formatting, when it could just be imported as a number.