Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
mcarotenuto
Contributor II
Contributor II

TAT Calculation without NULL Value

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

 

Labels (1)
5 Replies
Anil_Babu_Samineni

Try this?

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
mcarotenuto
Contributor II
Contributor II
Author

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

sunny_talwar

May be this

Only({<[Shipping date] *= {"*"}>} 
    NetWorksDay(RecevingDate, ShippingDate)
)
jonathandienst
Partner - Champion III
Partner - Champion III

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.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
mcarotenuto
Contributor II
Contributor II
Author

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.