Expression error

[nareshthavidishetty]

Hi,

I'm getting error when i use the below logic.Please provide the right expression.

Logic: aggr(if( Status_I_Min= null(), Interval( Status_A_Max - Status_null_Min, 'hh:mm:ss') and if(Interval( Status_A_Max - Status_I_Min, 'hh:mm:ss'),Application_Number)))

Thanks..

[sunny_talwar]

What are you trying to do? Can you elaborate? Provide sample?

[nareshthavidishetty]

Hi,

Below is the original expression.

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

Here i need to modify the expression as below.

if Status_I_Min= null() i need to 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)

Thanks..

[sunny_talwar]

May be this:

=Aggr(Interval(Status_A_Max - If(Len(Trim(Status_I_Min)) = 0, Status_null_Min, Status_I_Min), 'hh:mm:ss'), Application_Number)

[muthukumar77]

Hi,

Try like this,

if(Len(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))