Latest News / Articles
New Perth Head Office
Our growth over the last 12 months has finally caught up with us. After months of overcrowding...
more »
Come and see M-Power present at Insync10
Steve and Barry have been selected to present at this years Insync10 event, the topic - One an...
more »
Oracle Announce the Release of new Hyperion EPM Solution
We are all very excited here at M-Power, yes we’re that sad, to finally get our hands on the l...
more »
Upcoming Events
- no events atm
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:
Newsletters
These are the following newsletters:
Subscribe to our newsletters: