Hyperion Planning (MOSC)

MOSC Banner

Financial Reporting Divided by zero or negative

edited Nov 2, 2017 5:00AM in Hyperion Planning (MOSC) 1 commentAnswered

Hello there,

I'm building a simple budget variance report and is having a hard time getting the formulas right for $Variance and %Variance.

A little bit background:

Column A is Actual, Column B is Budget, Column C is $Variance (Actual - Budget), Column D is %Variance (Actual-Budget)/Budget

On the grid level, I have set #missing (no data) to 0, which I think causes problem later on in the $Variance and %Variance calculation.

I also set column C's formula to be [A]-[B].ifNonnumber(0), to avoid any #error. So far $VAriance column is calculating correctly.

The hard time I'm having with is the %Variance formula

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