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.
Hi
Try like this
=Sum({<accounts = {">=20*<=59*"}>}Actuals)
Hope that helps
sum(${<accounts={'>=20* <= 59*'}>}Actuals)
Thx for your response.
Actually that's what I tried but it returned 0.
😕
Thx for your response.
I also tried this alternative but it returned 0.
😕
Guys,
In other words, I'd like to have the similar result BUT in set analysis:
sum(if(wildmatch(Account,'20*','50*'),Actuals))
Thx for your help
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)
HI
Try like this
=Sum({<Account = {"20*","50*"}>}Acutals)
try this,
sum(if(wildmatch(Accounts,'20*','50*'),Actuals))
try this
sum(${<accounts={'20*',' 59*'}>}Actuals)