One selection selects another selection from listbox

bobbydave — Wed, 25 Nov 2020 16:16:04 GMT

I've a loader that takes in the below expressions:

if(MixMatch([Case Type],'CFIN','WFIN')and [Recd To Close] <=5,1) as [Completed CFIN Including Web <= 5 Days],

if(MixMatch([Case Type],'CFIN','WFIN')and [Recd To Close] <=10,1) as [Completed CFIN Including Web <= 10 Days],

if(MixMatch([Case Type],'CFIN','WFIN')and [Recd To Close] >10,1) as [Completed CFIN Including Web >10 Days],

if(MixMatch([Case Type],'CFIN','WFIN')and [Recd To Close] <=5,1) as [SLA CFIN Including Web <= 5 Days],

if(MixMatch([Case Type],'CFIN','WFIN') and [Recd To Close] >5 and [Recd To Close] <=10,1) as [SLA CFIN Including Web <= 10 Days],

if(MixMatch([Case Type],'CFIN','WFIN')and [Recd To Close] >10,1) as [SLA CFIN Including Web >10 Days],

In my app, I bring these expression values and put them in a listbox

=IF( [SLA CFIN <= 5 Days], 'SLA CFIN<=5 Days',

if([SLA CFIN <= 10 Days], 'SLA CFIN =<10 Days',

if([SLA CFIN > 10 Days], 'SLA CFIN>=10 Days',

if( [SLA CCIN <= 5 Days], 'SLA CCIN <= 5 Days',

if([SLA CCIN <= 10 Days], 'SLA CCIN <= 10 Days',

if([SLA CCIN > 10 Days], 'SLA CCIN > 10 Days',

if([SLA CCIN Including Web <= 5 Days], 'SLA CCIN Including Web <= 5 Days',

if([SLA CCIN Including Web <= 10 Days], 'SLA CCIN Including Web <= 10 Days',

if( [SLA CCIN Including Web >10 Days], 'SLA CCIN Including Web >10 Days'

)))))))))

My problem is when i make a selection from the listbox, when i select

'SLA CCIN <= 5 Days' from the listbox,

'SLA CCIN Including Web <= 5 Days then also gets selected.

the same applies to 'SLA CCIN <= 10 Days', then

'SLA CCIN Including Web <= 10 Days' gets selected also

and CCIN >10 also.

I've added a picture of me selecting CCIN <= 5 Days only

However a second selection is made of CFIN including Web >= 5 days.

**Note if I first select the other way around, as in, CCIN including Web, the second selection is not made. Weird

Anyone understand why 2 selections are made for 1 selection.

Thanks

Re: One selection selects another selection from listbox

Colin-Albert — Fri, 05 Jan 2018 17:19:49 GMT

Th think you need to change the order of the if statements in the listbox expression so the most inclusive statements come first.

i.e.

IF SLA CCIN inc Web ...

IF SLA CCIN ...

IF SLA CFIN ...

bobbydave — Mon, 08 Jan 2018 15:45:31 GMT

I've tried rearranging the order.

Its very strange that it is only the SLA CCIN will automatically select the SLA CCIN Incl Web.

Nothing has worked