networkdays - variable replacement not working

[jarno_loubser]

I'm trying to replace the holiday part of the networkdays function with values in a variable as part of the load statement.

My variable's value is: '2002-12-31','2008-01-01'

The following works:

load

...

networkdays (peek(INCIDENT_DATE),INCIDENT_DATE, '2002-12-31','2008-01-01')

resident ....;

The following ignores my holidays:

load

...

networkdays (peek(INCIDENT_DATE),INCIDENT_DATE, $(HoliDays))

resident ....,;

Please help.

[SunilChauhan]

i believe we can not assign multiple values into single variable,it need to declare seperately

for each holiday one variable

[Miguel_Angel_Baeyens]

Hi,

Just try instead

NetWorkDays(Peek('INCIDENT_DATE'), INCIDENT_DATE, '$(HoliDays)')

Note that both the field within Peek() and the variable HoliDays are single quoted.

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

[jarno_loubser · Accepted solution]

Like many problems this was solved by correctly spelling the variable in question. 😞