Announcements
cancel
Showing results for
Did you mean:
Creator III

## Pick match with else condition

Hello,

I am trying to create a calculated dimension with pick and match with only exception else condition that means if there is no match then pick 'Not in Months' value. I am using the following syntax. However it is showing '-' instead of 'Not in Months' .

It is not picking up the else statement when there is no match. Is there any way to make it to work .

=Pick(Match(Bucket, '01', '12', '23', '34', '45', '56')+1,
'Not in Months','0-1 Month', '1-2 Month ', '2-3 Month', '3-4 Month ', '4-5 Month', '5-6 ')

1 Solution

Accepted Solutions
MVP

May be try this

``````=Pick(RangeSum(Match(Bucket, '01', '12', '23', '34', '45', '56'), 1),
'Not in Months','0-1 Month', '1-2 Month ', '2-3 Month', '3-4 Month ', '4-5 Month', '5-6 ')``````
6 Replies
Creator II

Hi, Use below one

=Pick(1+Match(Bucket, '01', '12', '23', '34', '45', '56'),
'Not in Months','0-1 Month', '1-2 Month ', '2-3 Month', '3-4 Month ', '4-5 Month', '5-6 ')

MVP

May be try this

``````=Pick(RangeSum(Match(Bucket, '01', '12', '23', '34', '45', '56'), 1),
'Not in Months','0-1 Month', '1-2 Month ', '2-3 Month', '3-4 Month ', '4-5 Month', '5-6 ')``````
Creator III
Author

Hi Sunny, Awesome it works. Could you please help me to understand how rangesum works here in this case with else statement.

Creator III
Author

Hi Rajesh,

Thank you for your reply, i tried that too but did not work out.

MVP

I think what was happening was that the Match was giving null so Null + 1 = Null... but rangesum handles it differently.... RangeSum(Null, 1) = 1

Creator III
Author
Thank you for clarification.
Community Browser