Thread: Blank OLAP Data
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
sansimeon sansimeon is offline
external usenet poster
 
Posts: 7
Default Blank OLAP Data

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