Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Budget to Actual Variance Formula in Scenario Dimension help

F. ArabakSep 12 2012 — edited Sep 17 2012

I am trying to calculate the Budget to Actual variance by using a member formula in the Scenario dimension.

The formula I'm using is: @VAR("Final"->"Actual" -> &CurrentYear,"Budget");

This formula yields a value that equals the budgeted amount.

The Variance % formula I'm using is: @VARPER("Final"->"Actual" -> &CurrentYear,"Budget")/100;

This % formula equals 100% for most accounts, but is 200% or 300% for other accounts

What am I missing? Many thanks in advance

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 15 2012

Added on Sep 12 2012

#business-intelligence-applications, #performance-management-applications, #planning, #planning-and-budgeting

11 comments

952 views