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!
