Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm sure this is completely simple but here goes: How do I chart only business days?
Right now, my expression is =Date([IncCreated.autoCalendar.Date],'MM/DD/YY') but I do not want to include weekends. How do I do that?
Thanks!
With your expression, you could use:
=Date(if(Match(WeekDay([IncCreated.autoCalendar.Date]),'Mon','Tue','Wed','Thu','Fri')>0,[IncCreated.autoCalendar.Date]),'MM/DD/YY')
But it would more useful if you created a flag in your load script. You would use the similar if statement logic in your load script.
With your expression, you could use:
=Date(if(Match(WeekDay([IncCreated.autoCalendar.Date]),'Mon','Tue','Wed','Thu','Fri')>0,[IncCreated.autoCalendar.Date]),'MM/DD/YY')
But it would more useful if you created a flag in your load script. You would use the similar if statement logic in your load script.
PERFECT!!! Both ideas are excellent! Thank you Gary!!!!!!!!!!!!!!!!