Number Formatting - Named MDX Table


#1

Hi All,

We are using a named MDX table and currently formatting the results using {{cell.value | formatNumber:2}}. However, this is rendering zero values as “-”. Is there a way to get zero values to show as “0”?

Thanks,
David


#2

And as an extension to this, can tm1-ui-dbr results be formatted so zeros show as “0” instead of “-”?

Thanks,
David


#3

Hi @anz.fin.all.mailbox,

The tm1-default-empty property should help you out on this. Either set it to zero or an empty string.

Cheers!
Paul


#4

Thanks @plim,

I thought there was something like that but was looking at the dbr-read-only directive where it doesn’t exist. That’s perfect, thanks.


#5

Hi @anz.fin.all.mailbox,

Great! No worries! Thanks for the confirmation.

Cheers!
Paul