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
