AGGREGATION PROBLEM

[silvia_assuncao]

I I have an aggreation problem, could you please help me understand how to solve it.

[sunny_talwar]

May be this:

If(Dimensionality() = 0,

Sum(Aggr(

(Sum({$<[Account Expense as Country?] = {'1'}, Account_in_new_consolidation = {'Yes'} ,[Current year]={'Yes'},[Closing Period]={'$(=$(vMax_Closing_Period))'},[Company Code]={'Co-244','Co-627','Co-651','Co-653','Co-654','Co-659','Co-660','Co-445','Co-697','Regional'},[Corporate or LA]={'LA'} >}([Estimates_Local_Currency])))

/

((Sum({$<[Account Expense as Country?] = {'1'}, Account_in_new_consolidation = {'Yes'} ,[Current year]={'Yes'},[Closing Period]={'$(=$(vMax_Closing_Period))'},[Company Code]={'Co-244','Co-627','Co-651','Co-653','Co-654','Co-659','Co-660','Co-445','Co-697','Regional'},[Corporate or LA]={'LA'} >}([AOP_Local Currency])))

/

(Sum({$<[Account Expense as Country?] = {'1'}, Account_in_new_consolidation = {'Yes'} ,[Current year]={'Yes'},[Closing Period]={'$(=$(vMax_Closing_Period))'},[Company Code]={'Co-244','Co-627','Co-651','Co-653','Co-654','Co-659','Co-660','Co-445','Co-697','Regional'},[Corporate or LA]={'LA'} >}([AOP])))

),[Company Name])),

(Sum({$<[Account Expense as Country?] = {'1'}, Account_in_new_consolidation = {'Yes'} ,[Current year]={'Yes'},[Closing Period]={'$(=$(vMax_Closing_Period))'},[Company Code]={'Co-244','Co-627','Co-651','Co-653','Co-654','Co-659','Co-660','Co-445','Co-697','Regional'},[Corporate or LA]={'LA'} >}([Estimates_Local_Currency])))

/

((Sum({$<[Account Expense as Country?] = {'1'}, Account_in_new_consolidation = {'Yes'} ,[Current year]={'Yes'},[Closing Period]={'$(=$(vMax_Closing_Period))'},[Company Code]={'Co-244','Co-627','Co-651','Co-653','Co-654','Co-659','Co-660','Co-445','Co-697','Regional'},[Corporate or LA]={'LA'} >}([AOP_Local Currency])))

/

(Sum({$<[Account Expense as Country?] = {'1'}, Account_in_new_consolidation = {'Yes'} ,[Current year]={'Yes'},[Closing Period]={'$(=$(vMax_Closing_Period))'},[Company Code]={'Co-244','Co-627','Co-651','Co-653','Co-654','Co-659','Co-660','Co-445','Co-697','Regional'},[Corporate or LA]={'LA'} >}([AOP])))))

[silvia_assuncao]

but when If I open categories inside country, the total by category is not correct:

how can we fix it?

[sunny_talwar · Accepted solution]

What do you expect to see instead when you expand?

[silvia_assuncao]

Hi... you were correct.

thanks