Hey all,
I'm looking to use PowerPivot to indirectly pull unit closing information in a file I use regularly. Here are the relationships:
GLSummary[FinancialPeriod_Key] looking up FinancialPeriod[FinancialPeriod_Key]
GLSummary[GLAccount_Key] looking up GLAccounts[GLAccount_Key]
GLSummary[Company_Key] looking up Company[Company_Key]
GLSummary[Project_Key] looking up Projects[Project_Key]
The goal is to have the closings by project by financial period. A good proxy for closings is a count of the credits for GL Account 5000 which are greater than $10,000.
I tried putting the following formula as a measure in both the project table and the GLSummary table:
=calculate(count(GLSummary[Credit]),GLAccounts[GLAccount_Code]="5000",GLSummary[Credit]>"10000")
Both give me no results. Am I structuring this correctly?
I'm looking to use PowerPivot to indirectly pull unit closing information in a file I use regularly. Here are the relationships:
GLSummary[FinancialPeriod_Key] looking up FinancialPeriod[FinancialPeriod_Key]
GLSummary[GLAccount_Key] looking up GLAccounts[GLAccount_Key]
GLSummary[Company_Key] looking up Company[Company_Key]
GLSummary[Project_Key] looking up Projects[Project_Key]
The goal is to have the closings by project by financial period. A good proxy for closings is a count of the credits for GL Account 5000 which are greater than $10,000.
I tried putting the following formula as a measure in both the project table and the GLSummary table:
=calculate(count(GLSummary[Credit]),GLAccounts[GLAccount_Code]="5000",GLSummary[Credit]>"10000")
Both give me no results. Am I structuring this correctly?
