topic Re: fromular with networkdays not working in App Development

fromular with networkdays not working

peisenrot — Thu, 27 Jul 2023 06:19:03 GMT

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

Re: fromular with networkdays not working

marcus_sommer — Thu, 27 Jul 2023 13:05:19 GMT

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.