Thanks for this Lars!  Sorry for the late response.I'm going to play with this and see if I can get something to work.  If you think of anything else, let me know.  Thanks again.

^ What Kellie saidAlso, it's challenging to have the Planner focus the data you want to see, because it includes so much data and is not sortable.  For example, if I have a filter applied to show data for a specific role, and I want to see the planned hours assigned to this role during a given timef...

Hi Fusion Community,Can anyone provide instruction on how I can effectively look at programs and iterate down through their projects, their tasks, grab some data at the task level (Actual Hours), and then aggregate all Actual Hours for all of those tasks back up at the program level? My scenario wil...

Hi Chris!Sorry to bother you, it's just that I have question related to the above item you helped me with. The solution you provided was related to a scenario where there was only ever one program in the Event Trigger because the scenario was based off of individual project updates. I want to do the...

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