values comparaison

[master_student]

Hello Guys,

I have a table that compares two values and display dans les delais or Hors delais according to the result of comparaison

heres my  caculated dimension

=Aggr(

If( Sum(TOTAL <[Code Cas]> num#(Interval#(SLA_GLOBAL, 's'), 'm')) >

if([Criticité cas ] = 'Non Critique' and (segment = 'VLV' or segment = 'LV'

or segment = 'MV'

or segment = 'HD'

or segment = 'HV'

or segment = 'Premium'

),4320,

if([Criticité cas ] = 'Non Critique' and (segment ='LowEndUser' or segment = 'HighEndUser'

or segment = 'Entreprise'

),2880,

if([Criticité cas ] = 'Non Critique' and (segment ='One to one'

),1440

,

if([Criticité cas ] ='Critique' and (segment = 'VLV' 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

))))

,'Hors Delais'

,'Dans les delais')

,[Code Cas])

expression

SLA Globale :

num#(Interval(Interval#(SLA_GLOBAL, 's'), 'm'))

SLA objective :

if([Criticité cas ] = 'Non Critique' and (segment = 'VLV' or segment = 'LV'

or segment = 'MV'

or segment = 'HD'

or segment = 'HV'

or segment = 'Premium'

),'4320' ,

if([Criticité cas ] = 'Non Critique' and (segment ='LowEndUser' or segment = 'HighEndUser'

or segment = 'Entreprise'

),'2880',

if([Criticité cas ] = 'Non Critique' and (segment ='One to one'

),'1440'

,

if([Criticité cas ] ='Critique' and (segment = 'VLV' 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'

))))

[Anil_Babu_Samineni]

What is the issue?