UNDEFVALS rules function

Post Reply
Marcus Scherer
Community Contributor
Posts: 125
Joined: Sun Jun 29, 2008 9:33 am
OLAP Product: TM1
Version: 9.5 10.1 10.2
Excel Version: 2007
Location: Karlsruhe

UNDEFVALS rules function

Post by Marcus Scherer » Tue Oct 13, 2009 4:32 pm


is there something like a UNDEFVALS rules function in PALO. I need to distinguish 0 put in by a user from the default 0. Values are sent through Excel files, so as a workaround I would send a number little greater than 0 in order to be able to distinguish later.
If someone knows a better solution, let me know.

Thanks in advance,


User avatar
Michel Zijlema
Site Admin
Posts: 703
Joined: Wed May 14, 2008 5:22 am
OLAP Product: TM1, PALO
Version: both 2.5 and higher
Excel Version: 2003-2007-2010
Location: Netherlands

Re: UNDEFVALS rules function

Post by Michel Zijlema » Tue Oct 13, 2009 7:09 pm

Hi Marcus,

AFAIK it is not possible in PALO to make a distinction between empty and zero cells.
I can't think of a solution better than the workaround you're using right now.


Post Reply