Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, I have a question it is possible to make this formula not affected by the filter TIMEOFF?
networkdays(min(FTE_Calendar.StartDate), max(FTE_Calendar.EndDate),$(vHoliday2))
Regards,
Pablo
May be like this:
NetWorkDays(Min({<TIMEOFF>}FTE_Calendar.StartDate), Max({<TIMEOFF>}FTE_Calendar.EndDate),$(vHoliday2))
Do you have expression or hardcoded dates with vHoliday2? If it is an expression, you will need to add set analysis to ignore TIMEOFF there also
May be like this:
NetWorkDays(Min({<TIMEOFF>}FTE_Calendar.StartDate), Max({<TIMEOFF>}FTE_Calendar.EndDate),$(vHoliday2))
Do you have expression or hardcoded dates with vHoliday2? If it is an expression, you will need to add set analysis to ignore TIMEOFF there also
Thank you very much! This really help me, another question what if I have a Date dimension (AssignmentTimephasedDataSet.Month_Year) in a chart and want to avoid the same filter is that possible?
Not sure I complete follow you? Would you be able to try and re-explain it for me?
I have the dimension Month Year in a barchart would it be possible to avoid the filter TIMEOFF for that dimension. I already tried avoiding it with the set analysis expression but doesnt work. Any suggestion?