Avg working days??

[qlikuser222]

Hi Everyone,

I have a requirement where I need to calculate the avg. sales for given working days which excludes weekend and holidays.

Please find attached file which explains my requirement.

Can anyone please help me?

Thanks

[sunny_talwar]

Isn't 12th a Sunday and should not be counted also? Or do we only exclude dates which are in Holidays table?

[qlikuser222]

Hi,

Thanks for reply.

Weekends and also dates in Holiday table to be excluded.

Thanks

[sunny_talwar · Accepted solution]

May be this

=Sum(Sale)/NetWorkDays(Min(Date), Max(Date), $(=Concat(DISTINCT {<Holiday = {'*'}>} Chr(39) & Date & Chr(39), ', ')))