Range with * in set analysis

[thierrytt1102]

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.

[thierrytt1102]

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

[thierrytt1102]

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

[AbhijitBansode]

may be something like below:

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

[thierrytt1102]

It's gonna work but my exemple was quite simple compared to what I have to do 🙂  I'll still maintain my request open.
thanks for your time

[MayilVahanan]

HI

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

This is not works??

Otherwise try this also

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

[er_mohit]

ok

is what you are looking for

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