If (0) it didn't work, it may be because the cell is already formatted as a text entry rather than general formatting.Clear the formatting of the data area and then retry the (0) setting.
Works for Essbase Addin 7X and above.
Wednesday, June 24, 2009
Replacing #Missing label with 0 Zero not text 0
Put the #Missing label as (0) and excel will interpret it as a numeric zero.Technically, it's a negative zero.
If (0) it didn't work, it may be because the cell is already formatted as a text entry rather than general formatting.Clear the formatting of the data area and then retry the (0) setting.
If (0) it didn't work, it may be because the cell is already formatted as a text entry rather than general formatting.Clear the formatting of the data area and then retry the (0) setting.
Subscribe to:
Post Comments (Atom)
This comment has been removed by the author.
ReplyDeleteThanks for Information Our Online-Training-Informatica proven expert in all Hyperion Modules like Hyperion Financial Management, Hyperion Financial Data Quality, Hyperion Financial Reporting, Hyperion Essbase, Hyperion Planning, Smart view and Data Relationship management.Hyperion Essbase Online Training
ReplyDelete