Creating an analysis report value 0 not showing

Question

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

mickel rmeily · Answer

Dear @Venkat Koduvayur-Oracle

Thank you so much it worked

Regards

Venkat Koduvayur-Oracle · Answer

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 · Answer

Dear @Venkat Koduvayur-Oracle

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

Regards