values comparaison

[master_student]

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 :

[master_student]

any help please ?

[avinashelite]

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')

[Anil_Babu_Samineni]

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')

[PrashantSangle · Accepted solution]

good catch anil

looks like he is comparing interval formatted value with numeric value.

master_student‌

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,