Help with Complex Selection Member
Hello,
I am using Financial Reporting Studio 11.1.2.4.710. I am trying to build a complex selection member criteria for our account dimension. I can explain it best like this.
The Total_Cost member, excluding the (Labour, Benefits, and Other_Costs). The three accounts to be excluded are under the hierarchy of the Total_Cost member.
I have been fooling around with (), Nots, AND, OR, Union, and cannot get it correct. Every attempt I make, I always get the Total_Cost value. The other three accounts are never subtracted. There are values in the accounts.
So if you have an idea of how this expressions should look, please help me out with it.