hi..
I am trying to create a calculated members using select statement in the AS.
This is my statement.

Select SUM([Measures].[Amount])
FROM SMAFinancial
WHERE [GLGroup].[Gl Group].[300000-399999]

What I am trying to do is just to SUM the Amount for GLGroup in [300000-399999] from SMAFinancial cube.

But I got error saying that there is formula syntax error - token invalid.

Can anyone please help?

Thanks a lot.