Categories
- All Categories
- 153 Oracle Analytics News
- 28 Oracle Analytics Videos
- 14.8K Oracle Analytics Forums
- 5.7K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 54 Oracle Analytics Trainings
- 12 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 2 Oracle Analytics Industry
- Find Partners
- For Partners
Replacing 0 and nulls with hyphen (-) in obiee 12c
How can i replace 0 and nulls in a report in tabular format to hyphen ( - ) . I can get it done by converting the number to character . But i need it to be in the number format.
Answers
-
If you look at the help in the column properties where you can set the formal, you see the syntax to be used.
It's a typical <positive number format>;<negative number format>;<zero/null format>
You can't set a custom format for a not existing value, so if your cell is empty and not NULL, the format will not apply.
0 -
it is null
0 -
Actually a quick correction: the custom number format (https://docs.oracle.com/cd/E29542_01/bi.1111/e10544/format.htm#BIEUG13084 ) use the 3rd parameter for NULLs, not 0.
Therefore you need to adapt the formula to translate 0 into NULLs first if you want it to match the 3rd parameter of the custom number format.
0 -
it is displaying fine. but while i exported those hyphens are not displayed in the excel
0 -
I guess I saw something similar in MOS, there are a bunch of docs about export to Excel, worth having a look.
0
