UNDEFVALS function
-
- Regular Participant
- Posts: 269
- Joined: Tue Apr 21, 2009 3:43 am
- OLAP Product: Cognos TM1, Planning
- Version: 9.1 SP3 9.4 MR1 FP1 9.5
- Excel Version: 2003
UNDEFVALS function
I'd like to ask...how come when you apply UNDEFVALS in the rules..so empty cells appear empty & zero cells appear with zero. Testing the cube out...I put zero on a previously empty cell, so during zero suppression the data point with a zero isn't suppress...but when I clear the field cause I don't want any value, I can't make it appear empty. I assume when you use the data spread clear, you clear that cell as if there's no value.