Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Display Number as Number in Excel output of BI publisher report
Content
I have a report which displays employee ids as part of the report. Now when I export that excel output it shows as Number stored as text and it comes with that yellow warning in the cell with employee ids. I want to display employee number as a number in excel output of Report. I tried using to_number before employee ids in data model but it makes the report field as Double and long and still keeps storing that field as TEXT. Is there any way to make this field store as number on the excel output.
Regards
Tagged:
0