Set analysis

[Anonymous]

Hi,

How can I write the following expression so that I can include several account numbers?

sum({$<Account={'4645'}>}ClaimCost)

I would like the sum of account 4643, 4644, 4645, 4646, 4647, 4648 and 4649.

Thank you!

[robert_mika]

sum({$<Account={'4645','4644'.....}>}ClaimCost)

or create a variable

sum({$<Account={$(vAcc)}>}ClaimCost)

[rittermd · Accepted solution]

Try this

sum({$<Account={'4645',"4643","4644","4646","4647","4648","4649"}>}ClaimCost)

[sunny_talwar]

Or even without single quotes:

Sum({$<Account={4645, 4643, 4644, 4645, 4646, 4647, 4648, 4649}>}ClaimCost)

[Anonymous]

Thanks for your quick reply everyone!

It works with double quotes, single quotes and also without quotes.