New Scenario Formula
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 1 | Header 2 |
|---|---|
| FY16 | FY15 |
| BegBalance | BegBalance |
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!
Tagged:
0