Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello Guys,
I need your help,
I have two expression
sss: Interval(Interval#(SLA_INTERM, 's'), 'm')
=If(
ser ='Bo Facturation' and (
segment= 'VLV'
or segment='LV'
or segment='MV'
or segment='HV'
or segment='HD'
or segment='Premium'
), 2880,
if(ser ='Bo Facturation' and (
segment= 'LowEndUser'
or segment='HighEndUser'
or segment='Entreprise'
or segment='One to one'
), 1440,
if (
ser ='BO TECKNO ' and (
segment= 'VLV'
or segment='LV'
or segment='MV'
or segment='HV'
or segment='HD'
or segment='Premium'
or segment ='LowEndUser'
or segment ='LowEndUser'
or segment ='HighEndUser'
or segment ='Entreprise'
or segment ='One to one'
), 1440
,
if (
ser ='DT Support +Fixe + Delivery' and (
segment= 'VLV'
or segment='LV'
or segment='MV'
or segment='HV'
or segment='HD'
or segment='Premium'
), 2880
,
if (
ser ='DT Support +Fixe + Delivery' and (
segment= 'LowEndUser'
or segment='HighEndUser'
or segment='Entreprise'
or segment='One to one'
), 1440
and a fields that compare the two values, the problem is that : if(Column(1)>Column(2),'Hors Delais','Dans les delais')
the problem is there values of column 1 superior to the values of cloumn 2 but the text displays : Dans les delais :
good catch anil
looks like he is comparing interval formatted value with numeric value.
for your information interval function is a formatting function. It not converted the value of it
You can modify your 1st expression like below and try
sss: num(num#(Interval(Interval#(SLA_INTERM, 's'), 'm')))
Regards,
any help please ?
check the order of the expression ?? share the sample app that will help us to identify the issue ..
OR directly use the Expression name in the if condition like
if(Expname1>Expname2,'Hors Delais','Dans les delais')
Better if you provide sample to check, Because the input image is wrong as output receiving.
Are you estimating 2880, 1440, 1440, 2880, 1440 are the minutes?
If so, I could ask you to write something like
Interval(2880, 'mm')
good catch anil
looks like he is comparing interval formatted value with numeric value.
for your information interval function is a formatting function. It not converted the value of it
You can modify your 1st expression like below and try
sss: num(num#(Interval(Interval#(SLA_INTERM, 's'), 'm')))
Regards,