Hyperion Planning (MOSC)

MOSC Banner

New Scenario Formula

edited Mar 15, 2016 5:02AM in Hyperion Planning (MOSC) 2 commentsAnswered

Hi,

I am very new to creating calc scripts/formulas in Hyperion. I created a new scenario and I need to have a formula in it.

Header 1Header 2
FY16FY15
BegBalanceBegBalance

Go%...sample(30%)

Go%...sample(20%)
Get%...sample(80%)Get%...sample(80%)
Go/Get%...sample(24%)Go/Get%...sample(16%)

New Scenario: NETPRJC

Existing Scenario: PRJC

Period: BegBalance

Years: FY16

Account members: Go%, Get% and Go/Get %

Go/Get % = "Go %" * "Get %";

NETPRJC = "PRJC" * "Go/Get %";

In NETPRJC, I need to get the value in FY16. Can someone teach me the correct syntax for this? Many many thanks!

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