Hyperion Planning 11.1.2.1 - Time Balance = None
I have a planning form which has some Accounts in the rows (forecast sales volumes) and Periods in the columns (Jan to Dec and YearTotal).
At the moment, as I enter data for months, an aggregated value is updated in the YearTotal column, which is of course expected with a time Balance of Flow.
These forecast volumes get multiplied by promotion/marketing rates (also entered on a monthly basis) to create Marketing totals etc. but crucially the client wants the Year Total in this case to be Blank. For reasons beyond my understanding the None Time Balance in Planning applications is read as Flow.
Example (What currently occurs):
/ ¦ Oct ¦ Nov ¦ Dec ¦ Year Total
Sales Volumes ¦ 10 10 20 40
Rates per Vol. ¦ 2 3 2 7
Marketing Total ¦ 20 30 40 90
Example (What I'd like):
/ ¦ Oct ¦ Nov ¦ Dec ¦ Year Total
Sales Volumes ¦ 10 10 20 40
Rates per Vol. ¦ 2 3 2 ---
Marketing Total ¦ 20 30 40 90
Is this possible? Any help Gratefully received.
Ed