Greetings, I have a dimension of account numbers, like 100000-999999. Within
our account structure there are ranges of numbers that I would like to sum
together. For example, I need to sum accounts 771000 -> 771999. Are there
any functions that would let me return a set where the member name start
with 771.

Any help would be most appreciated
Thanks
John

Here, InStr() is useful.

Filter(Account.Members, InStr(1, Account.CurrentMember.Name, "771") = 1)

If you need, there is more string functions at "Registered Function
Libraries" from BOL.

Ohjoo Kwon
www.olapforum.com


"news.microsoft.com" <john.holton (AT) no_spamPulte (DOT) com> wrote