Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
OLAP Blank results in CUBEMEMBER and CUBECELL Formulas
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/comm...lic.excel.misc |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|