Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Try this
sum({$<Account={'4645',"4643","4644","4646","4647","4648","4649"}>}ClaimCost)
sum({$<Account={'4645','4644'.....}>}ClaimCost)
or create a variable
sum({$<Account={$(vAcc)}>}ClaimCost)
Try this
sum({$<Account={'4645',"4643","4644","4646","4647","4648","4649"}>}ClaimCost)
Or even without single quotes:
Sum({$<Account={4645, 4643, 4644, 4645, 4646, 4647, 4648, 4649}>}ClaimCost)
Thanks for your quick reply everyone!
It works with double quotes, single quotes and also without quotes.