Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
The result will be: 20* + 59* and not >=20* <=59*
That's nice but I'd like to avoid the If statement and use Set analysis instead.
may be something like below:
sum ( {< Accounts= {"20*"} + {"30*"} + {"40*"} + {"50*"} > } Actuals)
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
HI
sum(${<Accounts={'20*','59*'}>}Actuals)
This is not works??
Otherwise try this also
sum({<Accounts={'20*'> + <accounts = {'59*'}>}Actuals)
ok
is what you are looking for
sum( {$<Account = P({1<Account={">=20*<=50*"}>})>} Acutals)