Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I want to create an expression which sums up all values for all selections removed, except for one field.
sum( {1<Region= {US} >} Sales )
This sample from the help file is nearly what I need.
Just that I want to keep Region = 'Current Selection'.
How to specify 'current selected Region' in that context?
Thanks in advance,
Thilo
Ok,
got it:
sum( {1<Region={$(=Region)}>} Sales )
Thilo
I don't think that will work if you have no or more than one Region selected. I think this will, though (untested):
sum({1<Region={'$(=concat(Region,chr(39)&','&chr(39)))'} Sales)
I had same problem
Thanks John for your post it helps a lot.
You just skipped 2 chars >} before Sales
it should look like this and it work:
sum({1<Region={'$(=concat(Region,chr(39)&','&chr(39)))'}>} Sales)