Get Aging Request

[aenr]

Hi WF Community,

I'm trying to make a report to get the aging of the request. This will count the number of days until the request status changes to resolved, at which point it will stop counting the number of days. Tried the text mode below but doesn't give me any results.

aggregator.displayformat=HTML
aggregator.function=AVG
aggregator.namekey=datevariance
aggregator.valueexpression=ROUND(DATEDIFF($$TODAY,{entryDate}),0)
aggregator.valueformat=HTML
description=Aging Tickets
displayname=Aging Days
textmode=true
valueexpression=IF({status}="INP",ROUND(DATEDIFF($$TODAY,{entryDate}),0))
valueformat=HTML

[aenr · Accepted solution]

I think I got it. 

aggregator.displayformat=HTML
aggregator.function=AVG
aggregator.namekey=datevariance
aggregator.valueexpression=ROUND(DATEDIFF($$TODAY,{entryDate}),2)
aggregator.valueformat=HTML
description=Aging Tickets
displayname=Aging Days
textmode=true
valueexpression=IF({status}="INP",ROUND(DATEDIFF($$TODAY,{entryDate}),2),IF({status}="NEW",ROUND(DATEDIFF($$TODAY,{entryDate}),2),ROUND(DATEDIFF({actualCompletionDate},{entryDate}),2)))
valueformat=HTML