This discussion is archived
2 Replies Latest reply: Jan 11, 2013 12:09 PM by sunil k RSS

Referencing Members in Formula

949591 Newbie
Currently Being Moderated
Hello,

Here is a simple example of my problem that I am encountering in the Essbase Admin Console when trying to write a formula

ACCOUNTS:
Income
Income Tax Rate

I would like to add a new account in between these two called Net Income with the formula being: ="income"*(1-"income tax rate");

However, I am having issues, because the item I want to reference is below the item I want to use. As I understand, Essbase requires referenced members to be above the member in which you wish to reference it. Is there a way for me to solve this?

Thank you!!!

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points