Report column showing the difference between proof deadline and $$TODAY?

[JasonLe4]

I have a Proof Approval report that shows all reports that have pending approvals and a proof deadline earlier or equal to $$TODAY. I'd like a column that shows the difference between the proof deadline and $$TODAY.

I tried this:

valueexpression=ABS(WEEKDAYDIFF (documentVersion:proofDeadlineDate},{$$TODAY}))

valuefield=dateVariance

valueformat=HTML

aggregator.valueexpression=WEEKDAYDIFF({documentVersion:proofDeadlineDate},{$$TODAY})

aggregator.function=AVG

aggregator.valueformat=HTML

aggregator.namekey=datevariance

namekey=datevariance

displayname=Date Variance (Entry to Actual Completion Date)

textmode=true

description=Entry to Actual Completion Date

Obviously it didn't work. Suggestions?

Thanks!

[Richard_Le_ · Accepted solution]

Hi Jason,

Your syntax was a little off in your value expressions. You don't need curly brackets around wildcards, also when referencing multiple fields in a value expression you need to separate each field with it's own set of curly brackets and use a full stop inbetween the two fields that are referencing eachother (i.e. instead of {documentVersion:proofDeadlineDate}, it is {documentVersion}.{proofDeadlineDate})

Try the below instead:

aggregator.function=AVG

aggregator.namekey=datevariance

aggregator.valueexpression=WEEKDAYDIFF({documentVersion}.{proofDeadlineDate},$$TODAY)

aggregator.valueformat=HTML

description=Days until proof deadline

displayname=Days until proof deadline

namekey=datevariance

textmode=true

valueexpression=ABS(WEEKDAYDIFF({documentVersion}.{proofDeadlineDate},$$TODAY))

valuefield=dateVariance

valueformat=HTML

Best Regards,

Rich.

[JasonLe4]

Thanks Rich, that worked perfectly! Totally adding this to my textmode stack :D

Jason

[Richard_Le_]

Glad I could help!