Creating an analysis report value 0 not showing

mickel rmeily

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

Venkat Koduvayur-Oracle

Hi @mickel rmeily

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

mickel rmeily

Dear @Venkat Koduvayur-Oracle

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

Venkat Koduvayur-Oracle

Hi @mickel rmeily

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

mickel rmeily

Dear @Venkat Koduvayur-Oracle

Sorry for bothering and thank you again but i still can't know where to put it

Regards

Venkat Koduvayur-Oracle

Hi @mickel rmeily

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

mickel rmeily

Dear @Venkat Koduvayur-Oracle

Thank you so much it worked

Regards