TM1 Forum

Hi,

As per TM1's number formatting capability, is it possible to display - (dash) instead of space for (aggregated) cells that does not have any data?

Regards,

mce wrote:Hi,

As per TM1's number formatting capability, is it possible to display - (dash) instead of space for (aggregated) cells that does not have any data?

Regards,

If you edit the FORMAT attribute I would think so. It is definitely possible to display a blank rather than 0 ...

Here's the documentation for reference. It falls short of actually giving an example of a useful custom format but, to be fair, I've seen much worse examples of TM1 documentation.

An example of what you are looking for is: I had to do this directly in }ElementAttributes_DIMENSION NAME as the Attribute dialog didn't seem to let me make custom entries.

rmackenzie wrote:Here's the documentation for reference. It falls short of actually giving an example of a useful custom format but, to be fair, I've seen much worse examples of TM1 documentation.

An example of what you are looking for is:

Code: Select all

b:#,##0.00;-#,##0.00;-

I had to do this directly in }ElementAttributes_DIMENSION NAME as the Attribute dialog didn't seem to let me make custom entries.

yeah, I had looked at documentation but could not derive this format that you gave. as you said, documentation is quite poor. Many thanks.