Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a list box which displays timeperiod values like
1. November 2016
2. December 2016
3. Overall
4. YTD(Year till date)
5. Rolling 12 Months
I need to hide the below values in my list box. Kindly let me know the expression I need to use.
1. Overall
2. YTD(Year till date)
3. Rolling 12 Months
Thanks in advance
hi
You can 'Hide excluded' on general tab of list box properties.
Try like this
If(WildMatch(TimePeriod, "1. November 2016","2. December 2016"), TimePeriod)
hi,
see attached file
hope this helps
Thanks Frank,
Your solution worked. But the problem is my time period keeps on incrementing.
For Eg:- Currently it has 5 values, but it would keep on growing in which case your solution will not work for the months January 2017.... And the one String that will be common with the future values is "201". So our expression should check for the string "201" and not for the whole month name(November 2016).
1. Overall
2. YTD(Year till date)
3. Rolling 12 Months
4. November 2016
5. December 2016
6. January 2017
7. February 2017
8....
13 August 2017
Thanks for your response Anil
But your solution did not work. is there any other workaround ?
see attached file
hope this helps
When you ash this is not working. You may explain more. I've tag below reply still I didn't understand what your intend. Can you share data and expected output so that issue got work
Hi,