topic Re: TAT Calculation without NULL Value in App Development

TAT Calculation without NULL Value

mcarotenuto — Sat, 16 Nov 2024 19:34:40 GMT

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 — Wed, 27 Nov 2019 10:16:49 GMT

Try this?

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

mcarotenuto — Wed, 27 Nov 2019 12:28:23 GMT

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

sunny_talwar — Wed, 27 Nov 2019 12:58:01 GMT

May be this

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

jonathandienst — Wed, 27 Nov 2019 12:58:14 GMT

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 — Wed, 27 Nov 2019 13:28:11 GMT

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.