Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Reports using the Except Function — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Reports using the Except Function

Received Response
1
Views
1
Comments

Summary:

I have a list of all P&L accounts. I want to allocate them into three buckets. I want to add some members manually to the first 2 buckets and then have a list of all remaining accounts not allocated to either of the first two bucket.

Content (required):

I have a list of P&L accounts. I want to allocate them into three buckets. I have created an alternate hierarchy called "included accounts", another called "excluded accounts" and placed all the members from the main hierarchy as shared members within these. Then I want to create a third dynamic bucket for all other accounts that aren't in either of the first two buckets. I tried creating the third bucket dynamically using the except function but the members are still appearing in my report. See screenshot below. Am I doing something incorrectly or is this

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!