How to reference another dimension in an account formula?

[chrisfehlman]

Hi Everyone,

I am trying to create a calculated Account that references members from two different dimensions (Cost Center and Account)

Is there a way that I can reference a Cost Center dimension member in the Account Advanced Formula Editor to perform a basic mathematical equation?

For example, I want my equation to look something like this: (([Cost Center Member] + [Account Member]) / [Account Member]

Thanks!

[N1kh1l]

chrisfehlman

chrisfehlmanYou can use members from another dimension but not in the way you have shown. Other dimension members can be used in context like IF( [d/Costcentre] ="A", [Account1],[Account2]).

(([Cost Center Member] + [Account Member]) / [Account Member] , Here [Cost Center Member] is not a account and cannot be used to add to another account. [Cost Center Member] will have its values against some Account members only. If you want to use values of some accounts for a specific costcentre you can use LOOKUP([Account],[costcentre]="A").

May be explain your requirement with an example and it will be easier to understand your case and answer accordinlgy.

Br.

Nikhil