condition

[master_student]

Hello Guys,

I hope all is well.

I have a table that contains those fileds, every case id has so many status, I wanna keep only the cases that has one of those status:

[Statut Cas] = {'Fermé crédit', 'Fermé-remboursé', 'Fermé activation', 'Fermé BO', 'Fermé DT', 'Fermé Rétention', 'Fermé Rétention Client Perdu', 'Fermé Rétention Client Retenu'} and also the other status of those cases

the problem is in my table all cases appeared if they have closed status or not

Here are my expressions

sla globale :

=Num#(Interval(Sum({<[Code Cas] = p({<[Statut Cas] = {'Fermé crédit', 'Fermé-remboursé', 'Fermé activation', 'Fermé BO', 'Fermé DT', 'Fermé Rétention', 'Fermé Rétention Client Perdu', 'Fermé Rétention Client Retenu'}>})>}TOTAL <[Code Cas], [Date création], [Statut Cas], PROVIDER_GRP_ID> Interval#(SLA_GLOBAL, 's')), 'm'))

sla objective :

=If([Statut Cas] = 'Fermé crédit'OR [Statut Cas] = 'Fermé-remboursé'OR [Statut Cas] = 'Fermé activation'OR [Statut Cas] = 'Fermé BO'OR [Statut Cas] = 'Fermé DT'OR [Statut Cas] = 'Fermé Rétention'OR [Statut Cas] = 'Fermé Rétention Client Perdu'OR [Statut Cas] = 'Fermé Rétention Client Retenu'

AND (PROVIDER_GRP_ID = 'MAILING'or PROVIDER_GRP_ID = 'OCMAILING'or PROVIDER_GRP_ID ='RECL_HV' or PROVIDER_GRP_ID='RECL_LV' or PROVIDER_GRP_ID='RECL_MV' or  PROVIDER_GRP_ID ='SELF_CARE' or PROVIDER_GRP_ID='TECH' or PROVIDER_GRP_ID='UDRÉSIDEN' or PROVIDER_GRP_ID='URCORP' or PROVIDER_GRP_ID='URMOB2C' or PROVIDER_GRP_ID= 'URVASB2B' OR PROVIDER_GRP_ID='RÉCSOCIALM'or PROVIDER_GRP_ID='URVASRÉSID')and [Criticité cas ] = 'Critique', 1440,

If((PROVIDER_GRP_ID = 'MAILING'or PROVIDER_GRP_ID = 'OCMAILING'or PROVIDER_GRP_ID ='RECL_HV' or PROVIDER_GRP_ID='RECL_LV' or PROVIDER_GRP_ID='RECL_MV' or  PROVIDER_GRP_ID ='SELF_CARE' or PROVIDER_GRP_ID='TECH' or PROVIDER_GRP_ID='UDRÉSIDEN' or PROVIDER_GRP_ID='URCORP' or PROVIDER_GRP_ID='URMOB2C' or PROVIDER_GRP_ID= 'URVASB2B'OR PROVIDER_GRP_ID='RÉCSOCIALM' or PROVIDER_GRP_ID='URVASRÉSID')  and [Criticité cas ] = 'Critique' and (segment = 'VLV' or segment = 'LV'

or segment = 'LV'

or segment = 'MV'

or segment = 'HD'

or segment = 'HV'

or segment = 'Premium'

or segment = 'LowEndUser'

or segment = 'HighEndUser'

or segment = 'Entreprise'

or segment = 'One to one'

), 1440,

If((PROVIDER_GRP_ID = 'MAILING'or PROVIDER_GRP_ID = 'OCMAILING'or PROVIDER_GRP_ID ='RECL_HV' or PROVIDER_GRP_ID='RECL_LV' or PROVIDER_GRP_ID='RECL_MV'  or PROVIDER_GRP_ID ='SELF_CARE' or PROVIDER_GRP_ID='TECH' or PROVIDER_GRP_ID='UDRÉSIDEN' or PROVIDER_GRP_ID='URCORP' or PROVIDER_GRP_ID='URMOB2C' or PROVIDER_GRP_ID= 'URVASB2B'OR PROVIDER_GRP_ID='RÉCSOCIALM' or PROVIDER_GRP_ID='URVASRÉSID')  and [Criticité cas ] = 'Non Critique' and (segment = 'VLV' or segment = 'LV'

or segment = 'LV'

or segment = 'MV'

or segment = 'HD'

or segment = 'HV'

or segment = 'Premium'

), 1440,

if((PROVIDER_GRP_ID = 'MAILING'or PROVIDER_GRP_ID = 'OCMAILING'or PROVIDER_GRP_ID ='RECL_HV' or PROVIDER_GRP_ID='RECL_LV' or PROVIDER_GRP_ID='RECL_MV'  or PROVIDER_GRP_ID ='SELF_CARE' or PROVIDER_GRP_ID='TECH' or PROVIDER_GRP_ID='UDRÉSIDEN' or PROVIDER_GRP_ID='URCORP' or PROVIDER_GRP_ID='URMOB2C' or PROVIDER_GRP_ID= 'URVASB2B'OR PROVIDER_GRP_ID='RÉCSOCIALM'or PROVIDER_GRP_ID='URVASRÉSID') and [Criticité cas ] = 'Non Critique' and (segment ='HighEndUser'

or segment ='Entreprise'

or segment ='LowEndUser'), 2880,

if((PROVIDER_GRP_ID = 'MAILING'or PROVIDER_GRP_ID = 'OCMAILING'or PROVIDER_GRP_ID ='RECL_HV' or PROVIDER_GRP_ID='RECL_LV' or PROVIDER_GRP_ID='RECL_MV'  or PROVIDER_GRP_ID ='SELF_CARE' or PROVIDER_GRP_ID='TECH' or PROVIDER_GRP_ID='UDRÉSIDEN' or PROVIDER_GRP_ID='URCORP' or PROVIDER_GRP_ID='URMOB2C' or PROVIDER_GRP_ID= 'URVASB2B'OR PROVIDER_GRP_ID='RÉCSOCIALM'or PROVIDER_GRP_ID='URVASRÉSID') and [Criticité cas ] = 'Non Critique' and segment ='One to one',1440

))

)))

How to exclude the cases that haven't a closed status, and keep the ones who have closed status with the intermediate status

Thannnks

[vinieme12]

can you post sample app? also comment on the expected output