Oracle Fusion Data Intelligence

Welcome to the Oracle Analytics Online Forum!

We're thrilled to have you join our community of analytics enthusiasts and professionals. To enhance your experience and foster meaningful interactions, we encourage you to personalize your profile by setting up a display name and uploading a profile picture. Your display name will be how others recognize and engage with you in discussions, while a profile picture adds a personal touch to your forum presence.

Take a moment to update your profile with a display name and an image representing you. Let's create a vibrant and engaging community together!

Creating an analysis report value 0 not showing

Received Response
134
Views
6
Comments

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

  • 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

  • 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

  • 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

  • Dear @Venkat Koduvayur-Oracle

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

    Regards

  • 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

  • Dear @Venkat Koduvayur-Oracle

    Thank you so much it worked

    Regards