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