Average orders per day using weekdays

[#1]

Hi all,.

I am trying to calculate the average number or work orders per day but only taking into account weekdays

I think i need to use the network days function but am unsure how to write the expression.

My fields are

CountWorkOrder

avg(CountWorkOrder) will give me the average between the time scale selected, but i only want it to work it out per day over weekdays.

Can anyone help?

[#2]

Hi,

You can use the WeekDay() function:

IF(WeekDay(date_used) <> 'Sunday', AVG (CountWorkOrder))

Rebeca

[Gysbert_Wassenaar]

Try avg({<MyDate={'=networkdays(MyDate,MyDate)'}>}CountWorkOrder)

[akuttler]

Hello,

I have the same issue... I am trying to calculate Average Patient Visits per day for Weekdays only in given date range. My Field Names are 'Date of Service' and 'Visits'. I tried IF(WeekDay('Date of Service') <>'Sunday', AVG (VISITS))

The expression was accepted but It made no difference.