Hyperion Financial Reporting Products (MOSC)

MOSC Banner

Hyperion Financial Reporting - Calculating Percent of Subtotals?

edited May 27, 2015 11:19AM in Hyperion Financial Reporting Products (MOSC) 6 commentsAnswered

I am intending to use the Percent Of Total formula to calculate the percentage of a subtotal.  However, the formula provides a percent of all.  Is there a way to accomplish this?

I have included at the bottom an image of the actual grid, but for simplicity provided a basic example of the results I expect to come back and the results I'm actually getting back.

Anticipated Results:

AB

Cost Center

System Defined Member List Lev0

Basis Type

Children of Tier_2

Recipient

Descendants of All_Recipients

%

PercentofTotal([B],[B,3])

Total

CC_ABT_1RP_a15%15
CC_ABT_1RP_b

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