fromular with networkdays not working

[peisenrot]

Hello

I would like to use the formular 

sum({<CN_LifeCyleState = 'Incorporated'}>}NetWorkDays([CN_CreationDate.Date],[CN_ActualCompletionDate.Date])/count(distinct CN_Number)

but there is a mistake in. No idea if the networkdays is possible to use here. Please help

CN_Number is a text,

Best regards

Pia

[marcus_sommer · Accepted solution]

There is one curly bracket missing:

sum({<CN_LifeCyleState = {'Incorporated'}>} NetWorkDays([CN_CreationDate.Date],[CN_ActualCompletionDate.Date]) / count(distinct CN_Number)

Beside this try each part as separate expression within the wanted dimensionality to see if they return the expected results, for example if the dates are really dates and if all the used fields and any existing selections have also a valid association to each other.