Set Analisys with a Null () function

[Anonymous]

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.

[sasikanth]

try some thing like

Sum(if(not isNull(OrderRequestDate)and OrderDate>OrderRequestDate,NetWorkDays(OrderRequestDate,OrderDate)-1,0))/Count(OrderID)

[d_pranskus · Accepted solution]

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)