Any suggestions on how to replace blanks/null with zeros at the report level.  I understand how to do this within the data sets, but I need to know how to do it at the report level.  I have blanks in reports when I begin to merge data such as actuals, budgets, forecast, etc.  Thanks in advance.

Hey Doug,

Could you post a screenshot of the exact report you are having issues with so I can see what data elements aren't showing up as expected? I think we should see the 0's by default, but sometimes we can handle this with additional formatting a metric or synthetic column.

Thanks,

Justin

Hey Doug,

You could create a synthetic coloumn equal to the coloumn where you see blanks instead of zeros. When you create it you will see the options to make it a number and to make it summable.

Steps:

Click on the table where you have the data

Click on the data tab when the ad hoc query pops up and choose insert formula coloumn

Make the formula equal to the coloumn with the data in it that has blanks OR use the numeric value option if it is a metric

Choose the correct configuration of the coloumn so it is a number or currency and it is summable

This should work for what you are looking for but Justin is right. If it is a number format in the data it should have 0's instead of blanks so double check that to.

Let me know if you have any questions about this!

Thanks,

Lauren

I'll give this a shot.  Thanks for the feedback @Lauren Griessel

Doug,

I also have another idea for you if the first one does not work.  This on will definitely take care of your issue, but I am not sure the amount of work you would like to do.  Just to make sure I understand your question correctly, you are running into the below and you want to get rid of the BLANKS.

What you can do is create a new column and multiply your value by 1, which will not affect your reported numbers but it will fill in your BLANKS with $0.  I would recommend that you choose the Format of Currency, Type of Numeric, and Summable.  The other note I would add to this is if it is an Out of the Box report I would recommend trying to fix the values at the source and not the report to maintain the upgrade path.  If it is a custom report the above will work.

Thank you and let me know if this helps or have any other questions. 

Doug Mahan

Curious, but regardless of the blanks, when you export, does it come through with $0?  I have some reports that have the blanks as well, but after exporting the blanks are replaced with $0. 

@Doug Copeland

Did you happen to get what you were looking for and been able to implement?

-Ryan

Thanks to all who replied.  This issue was overcome by events.... I ended up redesigning the report due to some other issues.