How to display "0" in an empty cell

dfbbxm · July 18, 2018, 12:50am

When I use the tuple method to display the bug creation report

([Measures].[Issues created], [Issue Type].[Bug])

Some days did not create a bug，I want the corresponding cell to display “0”, Can you please help us ?

Ram.v · July 19, 2018, 8:03am

Please refer below set of code

IIF(IsEmpty(([Measures].[Issues created],[Priority].[Emergency])),0,
[Priority].[Emergency])

This will see if there is a empty cell, then the empty cell will be replaced as zero.

Hope this helps.

dfbbxm · July 20, 2018, 1:52am

Great, thanks for the support!

janis.plume · August 20, 2018, 2:56pm

Hi,

There is a standard function CoalesceEmpty in the MDX which can make the same code provided earlier more compact:

CoalesceEmpty([Measures].[Issues created],0)

Kindly,
Janis, eazyBI support

Daniel_Garcia · July 9, 2019, 7:48pm

Hi everybody,
How can I make the inverse?
I wanna display an empty cell when I find a 0 in the row.
I’m trying to use the Hide empty rows for having a report with no missing data.

Thanks

Peter_von_Hofer · July 10, 2019, 12:38pm

You can use
NonZero(<your statement>)