Hi,
I'm looking for a variation of this code that I found in another discussion.
valueexpression=CONCAT(ROUND(WEEKDAYDIFF({requestDate},{approvalDate}),1)," Days")
This works great for identifying how long approvals are actually taking.
I'd like a column in the report to report on how many days approvals have been in pending status.
Without having advanced reporting knowledge, I thought I could make a slight variation to the code above and replace approvalDate with $$TODAY but it doesn't seem to work.
valueexpression=CONCAT(ROUND(WEEKDAYDIFF({requestDate},{$$TODAY}),1)," Days")
Any thoughts for a reporting novice?