Workdays Calculation

Hi all,

Using the default Average Workdays in transition status, and found that it seems to be including weekends - ie if it goes into status on Friday, then comes out on Monday, that is showing as 3 days.

Any ideas why?

CASE WHEN [Measures].[Transitions from status] > 0 THEN
  [Measures].[Workdays in transition status] /
  [Measures].[Transitions from status]

Hi @auto98,

The workdays from the measures “Workdays in transitions status” are taken from the Time dimension settings specified in the eazyBI import options -

Check the settings and see if you have the correct non-working days selected.

Roberts //