Data Source Members to Reverse Sign for Expense Accounts: Only for Base Accounts possible?

Summary

Data Source Members to Reverse Sign for Expense Accounts: Only for Base Accounts possible?

Content

Dear all,

in the Data Source Dimension of FCCS, I implemented a special reporting hierarchy that dynamically reverses the sign (+/-) for Expense Accounts by a member formula. That works well for base expense accounts. However, it seems that by default, the dynamic calculation of Account Nodes is done after the dynamic calculation of the Data Source member formula. For my special Data Source hierarchy, this results in a wrong calculation of the P&L as the Expense Nodes are not correctly added/subtracted to the Net Income.