Blank OLAP Data

S

sansimeon

Our Cubevalue formula results in a blank where there is no data, we wish this
to show a zero. Under the excel OLAP addin for 2003 the Cubecellvalue
formual returns a zero, because we had the ability in the OLAP options to set
a default for blanks. WHERE HAS THIS GONE?

We have seen the work arround of using ISTEXT but that is not a workable
answer for what was a simple step in 2003
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top