Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'd like to sum the dalay between the order emission and the order request dates.
Data are valid only when the request date is not null, so I tried to reach the goal with the above formula:
Sum({ $<OrderRequestDate<>{Null()}>} If(OrderDate>OrderRequestDate,NetWorkDays(OrderRequestDate,OrderDate)-1,0))/Count(OrderID)
...but it doesn't work 😞
Would someone help me, pls?
Thanks.
N.
Hi
Set analysis to exclude null values (or actually include all non Null values) might be set as follows
SUM({$<OrderRequestDate = {*}>} If(OrderDate>OrderRequestDate, NetWorkDays(OrderRequestDate,OrderDate)-1,0))/Count(OrderID)
try some thing like
Sum(if(not isNull(OrderRequestDate)and OrderDate>OrderRequestDate,NetWorkDays(OrderRequestDate,OrderDate)-1,0))/Count(OrderID)
Hi
Set analysis to exclude null values (or actually include all non Null values) might be set as follows
SUM({$<OrderRequestDate = {*}>} If(OrderDate>OrderRequestDate, NetWorkDays(OrderRequestDate,OrderDate)-1,0))/Count(OrderID)