Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
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
1. =Pick(match(vTest,'EAD','RWA'),'Pick1','Pick2') // note the closing parenthesis
2. =Sum({<Dim1 = {'A','B'}>} EAD) // didn't you try this?
Also being moderated: