Hyperion Planning (MOSC)

MOSC Banner

Web Form Formulas Challenge

edited Dec 13, 2012 6:01AM in Hyperion Planning (MOSC) 1 commentAnswered
Hi,

We are looking for the syntax for a web form formula of an if-statement that would allow to have a row calculate different formulae depending on the column it comes across.

In the style of the below, but instead in the IF argument an statement that checks in which column we are:

IF( [3]<>0 ,          EVAL( ROUND( EVAL([A,3]-[B,5]),0) )           ,   EVAL(ROUND( EVAL([A,3]+[B,3]-[C,3]),0) )    )

We are assuming/experiencing following limitations/possibilities (if anyone can contradict, please reply that too!):

- Formulas are only possible on total rows or total columns, not in cells. As opposed to Cell validation, that can be cell specific :-(

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