UNDEFVALS rules function

Post Reply
Marcus Scherer
Community Contributor
Posts: 126
Joined: Sun Jun 29, 2008 9:33 am
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2016
Location: Karlsruhe

UNDEFVALS rules function

Post by Marcus Scherer »


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: 712
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 »

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