Latest News / Articles
User Group Meeting - Perth
The next Hyperion User Group will be held in Perth on the 23rd February 2012.
There is plenty...
more »
M-Power partners with 123OLAP to deliver Hyperion Training in Australia
M-Power is delighted to announce a partnership with the world's leading Hyperion training company 12...
more »
QUT talk about their Hyperion Planning project at the HEUG Conference
M-Power is delighted that Berndt de Bruyn of Queensland University of Technology has been ...
more »
Upcoming Events
Hyperion Training Course Dates
M-Power will be delivering training courses on Hyperion Planning and Hyperion Financial Management i...
more »
How to replace #missing with a true numerical zero rather than a text formatted zero
Essbase add-in users would be familiar with the concept of “missing” data. In the Essbase Options window (shown below) users can elect to select what character to show for missing data. Many users prefer to see a zero in order for any formulas written in excel to display. However the default behavior is to display as text which then means your excel formulas don’t work as you want them to.
The solutions is simple, enclose the zero in brackets as shown above in the Essbase Options Display tab. This is interpreted as a real zero in excel which will work with any formulae.
Selected Clients
Downloads
Latest downloads added:
- Applied HFM & Financial Reporting Training Course
- Applied Hyperion Planning & Essbase Essentials Training Course
- Hyperion Planning Accelerator Templates - Education Sector
Newsletters
These are the following newsletters:
Subscribe to our newsletters: