In script, I want to store my holidays in a variable, but I have some problem to use it in networkdays function. I try to calculate the number of holidays between 2 dates. Here is my script:
if(LOG_CNT=1, 'begin', if(TRAY_NO=peek(TRAY_NO), (networkdays(peek(AMD_DATE),AMD_DATE)-networkdays(peek(AMD_DATE),AMD_DATE,$(Holidays))), 'pb' ) ) as holidays_between,
When I try $(Holidays), I have only begin, pb and 0 values, so it's not working properly because between some dates I have holidays between.. When I try the formula with $(Holidays_script), I have an error message: ")" expected, but I don't know where it comes from. Does anyone have an idea for the good syntax?