Categories
- All Categories
- 145 Oracle Analytics News
- 27 Oracle Analytics Videos
- 14.7K 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
Creating an analysis report value 0 not showing
Deal ALL
I created an analytic for PPM with invoice and revenue and a column that calculate invoice- revenue
when i went to result I found that there are some contracts that doesn't have revenue yet so the column is blank and the remaining also
how to do it so i can have a value 0 ?
Regards
Answers
-
If you have created a table view, then you can have a formula with an expression as below
ifnull(column,0)
if you have created a pivot view, then you can suppress null with 0 by modifying the column data format with number format as
#,##0;-#,##0;0
Hope this helps
Regards
Venkat
0 -
thank you so much for your help
this formula ifnull(column,0) were should i insert it ?
I tried in the column -> Edit Formula
i didn't knew were to insert it
Thank you
Regards
Mickel
0 -
Yes in the edit formula
Pls replace the "column" with the actual measure column
ifnull("Project Billing - Revenue Transaction RealTime"."Revenue Transaction Measures".Revenue Amount",0)
Regards
Venkat
0 -
Sorry for bothering and thank you again but i still can't know where to put it
Regards
0 -
Yes it should be put in the edit formula. Like below
Pls replace "Summary"."Actual Sales Amount" below in the edit formula with the actual measure that you are trying to report.
If you still face difficulty, please share the XML from the Advance XML table and will modify and share the XML back where you can simply copy paste and apply that xml with the modified edit formula
Regards
Venkat
0 -
0