15 Replies Latest reply: Aug 9, 2013 8:28 AM by Mohit Sharma

# Range with * in set analysis

Dear,

Simple question, I'd like to sum Actuals from accounts 20* to 59*.

I was not able to find a way to handle this in set analysis,

Can someone help?

Thx a lot.

• ###### Re: Range with * in set analysis

Hi

Try like this

=Sum({<accounts = {">=20*<=59*"}>}Actuals)

Hope that helps

• ###### Re: Range with * in set analysis

Actually that's what I tried but it returned 0.

:-/

• ###### Re: Range with * in set analysis

sum(\${<accounts={'>=20* <= 59*'}>}Actuals)

• ###### Re: Range with * in set analysis

I also tried this alternative but it returned 0.

:-/

• ###### Re: Range with * in set analysis

Guys,

In other words, I'd like to have the similar result BUT in set analysis:

sum(if(wildmatch(Account,'20*','50*'),Actuals))

• ###### Re: Range with * in set analysis

Hi Their,

Do you know the length of account number.

If yes then create the lowest number(account number) and

highest number(account number)

and use them in set analysis.

Sum({<accounts = {">=200000000<=59999999999"}>}Actuals)

• ###### Re: Range with * in set analysis

HI

Try like this

=Sum({<Account = {"20*","50*"}>}Acutals)

• ###### Re: Range with * in set analysis

try this

sum(\${<accounts={'20*',' 59*'}>}Actuals)

• ###### Re: Range with * in set analysis

The result will be:  20* + 59*  and not  >=20* <=59*

• ###### Re: Range with * in set analysis

HI

sum(\${<Accounts={'20*','59*'}>}Actuals)

This is not works??

Otherwise try this also

sum({<Accounts={'20*'> + <accounts = {'59*'}>}Actuals)

• ###### Re: Range with * in set analysis

ok

is what you are looking for

sum( {\$<Account = P({1<Account={">=20*<=50*"}>})>} Acutals)

• ###### Re: Range with * in set analysis

try this,

sum(if(wildmatch(Accounts,'20*','50*'),Actuals))

• ###### Re: Range with * in set analysis

That's nice but I'd like to avoid the If statement and use Set analysis instead.

• ###### Re: Range with * in set analysis

may be something like below:

sum ( {< Accounts= {"20*"} + {"30*"} + {"40*"} + {"50*"} > } Actuals)

• ###### Re: Range with * in set analysis

It's gonna work but my exemple was quite simple compared to what I have to do :-)  I'll still maintain my request open.