Skip to Content
0
Former Member
Aug 13, 2009 at 02:17 PM

MDX Dimension formula - sum using property

204 Views

Hi All,

I am trying to add a dimension formula on the account dimension sheet and the goal is to add all the accounts that have a property TEST='Y' into a new account TESTACCOUNT

Here is the formula that I am using but it errors out while processing.

ID----


FORMULA

TESTACCOUNT----


SUM([ACCOUNT].[H1].properties("TEST")="Y"),solve_order=10

Can you please tell me where I am going wrong.

Thanks in advance for your help.

Swaroop

Edited by: SwaroopLalam on Aug 13, 2009 4:18 PM

Edited by: SwaroopLalam on Aug 13, 2009 4:19 PM