Thanks for the suggestions, Madalyn and Skye!  I had tried those without success in the many iterations of text mode.  You know what ended up working?  Creating a brand new column, per Skye's suggestion, and using this iteration:displayname=Actual Monthly Revenuetextmode=truevalueexpression={hours}*...

Hey Skye!1. Billing Rate is formatted as Currency2. The undesired result is blanks (nothing appearing in the calculated column)3. Here's the full text mode for that calculated column (Actual Monthly Revenue) displayname=Actual Monthly Revenuetextmode=truevalueexpression={hours}*{project}.{WF Program...

Thanks for the idea, Madalyn.  I tried that without any success.  It still doesn't produce a value in this calculated column.

Hi WF Community, I thought the following would be a fairly simple task for me, but I'm struggling to get the result I desire. Goal: have a calculated column called "Actual Monthly Revenue" on an hours report that derives a value from the following calculation:     - valueexpression={hours}*{project}...

Hi @JoshuaHa4 - With the help of Support, I ended up getting this working.  Here's how:"So in cases like this where we are jumping across multiple data tables, I've found that using valueexpressions tends to work more reliably than valuefields. I updated that and then added a displayformat option to...

Hi WF Community, I can't recall, can you subtract two aggregated values in a grouped report, or do I need to do this via a calculated field? For example: Thanks,Nick

Hi WF Community, I have an hours report.  I'm referencing a custom field at the program level (DE:WF Total Hours Sold) through a text mode column on the report.  This all works fine. I want to group the report and have this custom text mode column (DE:WF Total Hours Sold) display the MAX value in th...

Hi Doug!  Thanks as always.  The tip (up, then down) worked!Your app looks great.  I'll put it in front of some people on my side...it's always a question of budget over here.

Hi WF Community,I'm trying to produce a project baseline report that shows any baselines where the name contains "extended" in it.  In addition to showing these baselines, grouped by project, I also want to surface the Planned Completion Date for the baseline under each project that is marked as the...

Thanks, Chris!