set and pick

[priyarane]

Hi Community,

Can you please advise on below

1. Pick(match(vTest,'EAD','RWA','Pick1','Pick2')

so here I am looking like if(vTest='EAD', 'Pick1',if(vTest='EAD','Pick2') - how can I do with Pick

2. Sum(EAD)  where Dim1 ='A' , Dim1='B'

so Can I go like Sum({<Dim1 = {'A','B'}>}EAD) or Sum({<Dim1 *= {'A','B'}>}EAD)

[sunny_talwar]

You just need a extra parenthesis for the 1st one, I believe:

Pick(Match(vTest,'EAD','RWA'),'Pick1','Pick2')

For the second one, it seems both the expression will work the same without selection, will have different reaction to selection in Dim1.

Sum({<Dim1 = {'A','B'}>}EAD) -> Won't change with selection in Dim1

Sum({<Dim1 *= {'A','B'}>}EAD) - > Will show intersection of your selection and Dim1 = A, B. So if you have not selected A or B in your selection, you won't see anything with this expression.

HTH

Best,

Sunny

[sunny_talwar · Accepted solution]

[jonathandienst]

1.  =Pick(match(vTest,'EAD','RWA'),'Pick1','Pick2')    // note the closing parenthesis

2.  =Sum({<Dim1 = {'A','B'}>} EAD)      // didn't you try this?

[rubenmarin1]

Also being moderated: