Workfront

ChristianSi · 4/27/22

I want to calculate the sum of an expense that is entered on a custom form across various projects in a single report column to display a total. Text mode seems to be the answer, but I'm not even sure where to start with it.

skyehansen · 4/28/22

I don't really do anything in the expense side of things but it would seem to me that you could just use the existing summarize functionality (available on any numerically-formatted field). Is there something about this that isn't working for you?

ChristianSi · 4/29/22

I realized that my field was set to text rather than currency so I can now see the options to summarize. The broader issue is that this is being run on a project report, because we do not currently use the expense or finance areas of the application (long story).

I set summary to SUM and switched to text mode because I need the display name to be different. I'm not getting any summary results with the below.

aggregator.displayformat=customNumberAsCurrency

aggregator.function=SUM

aggregator.namekey=Actual Estimate

aggregator.valuefield=DE:Actual Estimate

aggregator.valueformat=customNumberAsDouble

displayname=Combined Actual Estimate

linkedname=direct

namekey=Actual Estimate

querysort=DE:Actual Estimate

textmode=true

valuefield=Actual Estimate

valueformat=customNumberAsCurrency

skyehansen · 4/29/22

I don't want to state the obvious, but there's not really enough data in here to figure out what the problem is, so here's my best guess. Did you know you need to have at least one grouping "set" in order to see a sum total? If you have no groupings, Workfront doesn't really know what you want to "total".