Getting a datediffworkdays from Open to Done

Questions & Answers
1

Trying to get a datediff per issue, not getting any values.
any ideas why?

Datediffworkdays(
([Measures].[Transition to status first date],[Transition].[Open=> In Progress]),
([Measures].[Transition from status last date],[Transition].[In Progress=>closed]),‘56’)

Thanks

2

The names you use in the Transition dimension to reference the transitions need to match the dimension member names exactly - case sensitive as well as all the spaces. By default there should be space before and after ‘=>’ as well as transition names usually begin with capital letters. The easiest way to make sure correct transition names are used is to bookmark the transitions in Transition dimension and then copy them from calculated member section.

Please try the following formula

DateDiffWorkDays(
([Measures].[Transition to status first date],[Transition].[Open => In Progress]),
([Measures].[Transition from status last date],[Transition].[In Progress => Closed]),'56')
3

Thanks, Your reply was helpful, but the problem actually was more of a workflow logic fallacy than syntax issue…