Hi,
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,
Marcus
UNDEFVALS rules function
-
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
-
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
- Contact:
Re: UNDEFVALS rules function
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.
Michel
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.
Michel