Hyperion Planning - Set Missing on Form Formula
Hi all,
I'd like to set a #Missing value as output of Form Column formula
To be more specific, I'd like the formula worked in this way:
IfThen( <Condition>, Eval( [A] - [B] ), #Missing )
As you already know, the above formula can't be validated.
So, I'm using the following workaround:
- I've created a hidden formula column [C] that does not do anything
- I've changed the formula in the following way:
IfThen( <Condition>, Eval( [A] - [B] ), [C] )
This solution works, but I don't like it
Is there a way to set a #Missing value directly on formula?
Thanks in advance