NetWorkDays not working

[TomBond77]

Hi experts

I have this formula, but it is not working: 

NetWorkDays('Created', '%Date of incident' )

The field values look like this...where is the problem?

Thank you.

[tresesco · Accepted solution]

Try removing the single quotes around the field names

[TomBond77]

but unfortunately it is not calculating the right figures:

any ideas?

[tresesco]

Do you need to change the order of the fields?

[TomBond77]

yes, thanks.

[TomBond77]

I have enhanced this formula  now with a restriction:

NetWorkDays(

{<[Incidents.Commuting Accident]-={'true'}>}

[Incidents.incidentDate], [Incidents.IncidentCreated] )

I would have expected for the last two records no calculation...do you see the error cause?

[tresesco]

Set analysis allowed only in aggregation functions.

[TomBond77]

okay, but how should the formula look like?

[tresesco]

Simple IF may be, like :
If(<cond>, networkdays(..)). Then suppress blank if needed