Sum( NetWorkDays()) gives unexpected result

Wed, 28 Aug 2013 09:40:13 GMT

sum( {$<[ResourceId Hours per week] = {">0"} >} (NetWorkDays($(vBeginDate4), $(vEndDate4)) * 8 * 60 * $(vTimeUnitFactor) * [ResourceId Hours per week]/40) -
if([Unavailable Start Date] < $(vEndDate4) and [Unavailable End Date] > $(vBeginDate4),
      (NetWorkDays(if([Unavailable Start Date] < $(vBeginDate4), $(vBeginDate4), [Unavailable Start Date]),
           if([Unavailable End Date] < $(vEndDate4), [Unavailable End Date], $(vEndDate4))) * 8 * 60 * $(vTimeUnitFactor) * [ResourceId Hours per week]/40 )
      , 0
      )
)

What i,m trying to do is calculate nettoworkdays: totaal workdays - unavailable days

The unavailable days are in a separate table and link via a ResourceId?

The problem is, when there are only 0 or 1 unavailable days records in a specific period, the calculation works fine.

But when there are more I get enexpected results e:g

Numer of unavailable days = 18

Bruto workdays = 92

Expected = 74

Count( 'above expresion' ) gives = 3

So I assume that the problem somehow is related to the number of unavailable days records.

Gerry

topic Sum( NetWorkDays()) gives unexpected result in QlikView

Sum( NetWorkDays()) gives unexpected result