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
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/com...a-772212c9a5b4&dg=microsoft.public.excel.misc
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
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/com...a-772212c9a5b4&dg=microsoft.public.excel.misc