Eric, Yes you'll need the customAPI module. You could upload to Workfront (as well as a new version if you want history)

I read that as OP asked for "not using matrix"  Your report thought gives exactly what OP described, neat!  

Right but how do I get to OP's ask of seeing a list of users and which projects they're actually on? I can do a project report filter out users without assignments. But I can't make it list users.I can do a user report and filter out those that aren't project users What am I missing? 

This might fit the bill - so you can either report on  hourswork items/assignments The latter gives you the sum, see example here 

Kindly provide more context as there's no way to help you otherwise. 

Best I can come up with is this: Work Item report grouped by User, then Project Sadly we can't report on ProjectUsers. A User has a "workItems" collection that point to projects but there's no way to get a list of unique projects out of it...Hope this helps!   

works fine for me across 3 groupings example column valueexpression=if({hourType}.{name}="General Overhead", {hours}, 0) valueformat=double aggregator.valueexpression=if({hourType}.{name}="General Overhead", {hours}, 0) aggregator.function=SUM aggregator.valueformat=doubleAsDouble aggregator.displa...

Hi @SamuelSh3  To your second question first: In WF reporting you can only ever modify attributes of the business object on which the report is based. If it's a task report - you cannot modify project attributes and vice versa.    If the %complete is inadequate try a Milestone View on a project rep...

One way is to "save" initial planned dates as "set-once" calculated fields, and then show slippage in a second calculated field.  IF(ISBLANK({DE:myOrigPlannedCompletion})&&{status}="CUR", {plannedCompletionDate}, {DE:myOrigPlannedCompletion}) The above will set the field ONLY if it's still empty, an...

Have you tried adding the calculation to the aggregator: aggregator.displayformat=doubleAsInt aggregator.function=SUM aggregator.namekey=hours aggregator.valueexpression=IF({hourType}.{name}="X40",{hours},0) aggregator.valueformat=doubleAsInt displayname=Test SUM linkedname=direct namekey=hours quer...