Hi Skye,Thank you for your time and insight here - you were correct in that 'Actual Duration Wks' is NOT a custom field, it is a calculated column in the report.  This helped me get the results I needed - the Actual Duration Wks is calculated from other data points, so I copied that calculation itse...

Thank you so much!  I have stripped out a lot of stuff now (appreciate that advice!), but still getting the same results - below is my revised formula:displayname=Active Weekstextmode=truevalueexpression=SUB({DE:Actual Duration Wks}, {DE:# of Days On Hold})valueformat=doubleAsInt  Question - would t...

Hi @sky - thank you so much.  Honestly, I was guessing on some of this, and using some previous formulas.  Thank you for the tips!  I have adjusted a few things, but I cannot change the '# of Days on Hold' to remove the hashtag as that is a custom field, and I have to request someone else to change ...

Hi there - can someone help me figure out the following?  I have 2 Custom Fields, and I need to subtract one from the other, but cannot seem to get it to work. I created the Custom column for a Report 'Active # of Weeks'; I need to subtract the # of Days on Hold from the Actual Duration (Days) to ge...