IF condition not working

[nareshthavidishetty]

Hi ,

I have used the below if condition but it is not giving correct results.

Condition:

=if(Len(Status_I_Min)= null(),

aggr(Interval(Status_A_Max-Status_Null_Min,'hh:mm:ss'),Application_Number),

aggr(Interval(Status_A_Max-Status_I_Min,'hh:mm:ss'),Application_Number))

Scenario(Please refer below image):

Condition for Total time taken to approve application  Column

if Total time taken to create application is null then show aggr(Interval(Status_A_Max-Status_Null_Min,'hh:mm:ss'),Application_Number) 

else

aggr(Interval(Status_A_Max-Status_I_Min,'hh:mm:ss'),Application_Number)

But here am not able to show the results if  Total time taken to create application is null.

[hector_munoz]

Hi,

Change "Len(Status_I_Min)= null()" by "Len(Status_I_Min) = 0".

Regards,

H

[nareshthavidishetty]

Hi,

I have tried it but no luck.

Thanks..

[Anil_Babu_Samineni]

Can you send latest expression which you tried

Can you try Simple '' or '0'

=if(Len(Status_I_Min)= '',

aggr(Interval(Status_A_Max-Status_Null_Min,'hh:mm:ss'),Application_Number),

aggr(Interval(Status_A_Max-Status_I_Min,'hh:mm:ss'),Application_Number))

[jonathandienst]

Where are you using this expression? All the fields are naked (ie not inside an aggregation function like Sum, Count, Max) and so will not return anything unless there is only one possible value where the expression is being evaluated. That's why you are getting nulls; and what purpose does the Aggr() serve?

I think the expression you need is (if Status_I_Min as an empty string or null):

     Sum(Status_A_Max - Alt(Status_I_Min, Status_Null_Min))

Format this to interval using the Property | Number for the table.

If Status_I_Min is zero, then:

     Sum(Status_A_Max - If(Status_I_Min <> 0, Status_I_Min, Status_Null_Min))

[nareshthavidishetty]

Hi,

We taking the time interval difference and i thin aggregation wont help us.

Thanks..

[nareshthavidishetty]

Hi,

Still its not working.

Thanks..

[Anonymous]

Hi,

Did you try:

if(isNull(Status_I_Min) or len(trim(Status_I_Min)) = 0,

aggr(Interval(Status_A_Max-Status_Null_Min,'hh:mm:ss'),Application_Number),

aggr(Interval(Status_A_Max-Status_I_Min,'hh:mm:ss'),Application_Number))