4 Replies Latest reply: Sep 12, 2016 8:37 AM by Madeleine Josefsson

Set analysis

Madeleine Josefsson Sep 12, 2016 8:17 AM

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!

Re: Set analysis

Robert Mika Sep 12, 2016 8:28 AM (in response to Madeleine Josefsson)

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

or create a variable

sum({$<Account={$(vAcc)}>}ClaimCost)
Like Show 0 Likes (0)

Actions
Re: Set analysis

Mark Ritter Sep 12, 2016 8:24 AM (in response to Madeleine Josefsson)

Try this
sum({$<Account={'4645',"4643","4644","4646","4647","4648","4649"}>}ClaimCost)
Like Show 0 Likes (0)

Actions
Re: Set analysis

Sunny Talwar Sep 12, 2016 8:28 AM (in response to Madeleine Josefsson)

Or even without single quotes:

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

Actions
Re: Set analysis

Madeleine Josefsson Sep 12, 2016 8:37 AM (in response to Madeleine Josefsson)

Thanks for your quick reply everyone!

It works with double quotes, single quotes and also without quotes.
Like Show 1 Like (1)

Actions