Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
can anyone tell me where the error is in this please?
AVG(
IF(
min(FLOOR([Work Order First Response Date])) > Max(FLOOR([Work Order Request Date])),
networkdays(Max(FLOOR([Work Order Request Date])), min(FLOOR([Work Order First Response Date]))),
networkdays(min(FLOOR([Work Order First Response Date])), Max(FLOOR([Work Order Request Date])))
)
)-1
You are trying to use an aggregation within an aggregation without using the Aggr() function
AVG(
Aggr(
IF(
min(FLOOR([Work Order First Response Date])) > Max(FLOOR([Work Order Request Date])),
networkdays(Max(FLOOR([Work Order Request Date])), min(FLOOR([Work Order First Response Date]))),
networkdays(min(FLOOR([Work Order First Response Date])), Max(FLOOR([Work Order Request Date])))
)
, AggregatingDimension/s)
)-1