Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have list box with the following values.
I need to set a condition to show different charts when specific values are selected. For example, any time that Last Man Standing, Remaining TSA's, TSA Exit Early In Progress or TSA Exited are selected show chart 1.
If any combination for both charts is selected show both charts.
Anytime that any of these values (OTC apps decom completed, OTC apps decom in progress or Remaining OTC apps) are selected show chart 2.
I've been building the following condition, but it's very tedious and I'm sure that I'm missing possible combinations. There has to be a better way.
=if(isnull(GetFieldSelections([ITLT Dashboard Status]))
OR match(GetFieldSelections([ITLT Dashboard Status]),'TSA Exited','TSA Exit Early In Progress','Last Man Standing','Remaining TSA'&chr(39)&'s'
,'Last Man Standing, Remaining TSA'&chr(39)&'s'
,'Last Man Standing, TSA Exit Early In Progress'
,'Last Man Standing, TSA Exited'
,'Remaining TSA'&chr(39)&'s, TSA Exit Early In Progress'
,'Remaining TSA'&chr(39)&'s, TSA Exited'
,'TSA Exit Early In Progress, TSA Exited'
,'Last Man Standing, Remaining TSA'&chr(39)&'s, TSA Exit Early In Progress'
,'Last Man Standing, TSA Exit Early In Progress, TSA Exited'
,'Last Man Standing, Remaining TSA'&chr(39)&'s, TSA Exited'
,'Remaining TSA'&chr(39)&'s, TSA Exit Early In Progress, TSA Exited'
,'Last Man Standing, Remaining TSA'&chr(39)&'s, TSA Exit Early In Progress, TSA Exited'
,'Last Man Standing, OTC apps decom completed'
,'Last Man Standing, OTC apps decom in progress'
,'Last Man Standing, Remaining OTC apps'
,'Remaining TSA'&chr(39)&'s, OTC apps decom completed'
,'Remaining TSA'&chr(39)&'s, OTC apps decom in progress'
,'Remaining TSA'&chr(39)&'s, Remaining OTC apps'
,'TSA Exit Early In Progress, OTC apps decom completed'
,'TSA Exit Early In Progress, OTC apps decom in progress'
,'TSA Exit Early In Progress, Remaining OTC apps'
I don't think you need to check for the explicite combinations, do you?
Maybe try like
= WildMatch( Concat(DISTINCT [ITLT Dashboard Status], '||'), '*TSA*', '*Last man standing*')
I don't think you need to check for the explicite combinations, do you?
Maybe try like
= WildMatch( Concat(DISTINCT [ITLT Dashboard Status], '||'), '*TSA*', '*Last man standing*')
That worked perfectly! Thank you for saving me hours of needless work!