2 Replies Latest reply: Jan 11, 2013 2:09 PM by sunil k RSS

    Referencing Members in Formula


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

      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!!!