Expand my Community achievements bar.

The next phase for Workfront Community ideas is coming soon. Learn all about it in our blog!

Count only hours during Weekdays

Avatar

Level 2

Hi WF Community.

 

I just want to consult the text mode below. How do I exclude the weekends from this report? I tried to use WEEKDAYDIFF, but the result is not what I'm looking for. It will only display hours greater than or equal to 24 hours, but if it is less, it will only show 0.

 

description=Aging Tickets
displayname=Aging Hours
textmode=true
valueexpression=IF({status}="INP",ABS(ROUND(DATEDIFF($$TODAY,{entryDate}),2))*24,IF({status}="NEW",ABS(ROUND(DATEDIFF($$TODAY,{entryDate}),2))*24,ABS(ROUND(DATEDIFF({actualCompletionDate},{entryDate}),2))*24))
valueformat=HTML

1 Reply

Avatar

Community Advisor

@A_EN - WEEKDAYDIFF is going to include timestamps which could skew the data. You might need to combine a CLEARTIME with WEEKDAYDIFF to get it to work.