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