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
Grid Formulas Referencing row's or columns with Dynamically determined Members — 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

Grid Formulas Referencing row's or columns with Dynamically determined Members

Received Response
23
Views
8
Comments
edited Aug 30, 2020 12:52AM in Narrative Reporting 8 comments

Summary

Is there a way to set up a formula that references a row or column that uses a function to determine the members

Content

Hello All, 

I am trying to figure out a way to set up a simple row formula, that references two other rows which are populated by multiple members using functions.  Specifically the Formula is Difference([2],[4])

However rows 2 and 4's POV are BottomMember of "Labor".  I am trying to set up a formula that will calculate the difference for each bottom level member of that hierarchy.  Currently the formula just calculates the difference between the sum of all the members in rows 2 and 4. 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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