TAT Calculation without NULL Value

[mcarotenuto]

Hello, I need support to create a TAT calculation without consider the NULL value, normally should i use 

networksday(RecevingDate,ShippingDate) i need to have it only fo the value with shipping date not null. How can i do it? thanks Massimiliano

[Anil_Babu_Samineni]

Try this?

networksday(RecevingDate,If(Not IsNull(ShippingDate), ShippingDate))

[mcarotenuto]

Thanks,i tried but i have every time the result -

[sunny_talwar]

May be this

Only({<[Shipping date] *= {"*"}>} 
    NetWorksDay(RecevingDate, ShippingDate)
)

[jonathandienst]

Is this what you are after?

=If(Len(ShippingDate) > 0, networksday(RecevingDate,ShippingDate), null())

Will return null() if shipping date is null or an empty string.

[mcarotenuto]

i have again the error as result, maybe to help the support can be important say that i'm using this formula in the KPI.