average function

[#1]

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

[sunny_talwar]

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