Hyperion Planning (MOSC)

MOSC Banner

Hyperion Planning - Set Missing on Form Formula

edited Feb 24, 2016 12:43PM in Hyperion Planning (MOSC) 4 commentsAnswered ✓

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:

  1. I've created a hidden formula column [C] that does not do anything
  2. 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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center