Non working days

hi
how i can edit the formula to exclude non workdays that are defined in the settings of eazybi

– days in transition status when issue was in this status in previous times
Cache([Measures].[Days in transition status]
+
– days since last transition to this status
NonZero(SUM(Filter(
Descendants([Issue].CurrentMember, [Issue].[Issue]),
IIF([Transition status].CurrentHierarchyMember.Level.Name = “Transition status”,
[Transition status].CurrentHierarchyMember.Name = [Measures].[Issue status], 1)
),
CASE WHEN
[Measures].[Issues history] > 0
THEN
DateDiffDays(
[Measures].[Issue status updated date],
Now()
)
END
)))

Hi @abdulaziz_aldhubaib,

You can replace the measure “Days in transition status” with “Workdays in transition status” in the formula. And use the DateDiffWorkdays() function instead of DateDiffDays(). The formula then could look similar to the one below:

Cache(
  [Measures].[Workdays in transition status]
  +
  NonZero(SUM(Filter(
  Descendants([Issue].CurrentMember, [Issue].[Issue]),
  IIF([Transition status].CurrentHierarchyMember.Level.Name = “Transition status”,
  [Transition status].CurrentHierarchyMember.Name = [Measures].[Issue status], 1)
  ),
  CASE WHEN
  [Measures].[Issues history] > 0
  THEN
  DateDiffWorkdays(
  [Measures].[Issue status updated date],
  Now()
  )
  END
  ))
)

Best,
Roberts // support@eazybi.com