Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Cue the extraordinary. Show-stopping experiences that raise the digital bar. Apply now for the 2023 Adobe Experience Maker Awards.

Need to add up all values of custom calculation

Avatar

Level 2

I have been able to get a percentage calculation by dividing the values in the hours column by 35 in the Utilization Percentage column, but would like to add all those up to get a total percentage.  I'm relatively new to text mode and tried to Frankenstein things together from other columns.  Does anyone have the answer to getting the SUM to calculate at the top of the column?  NOTE: I fully realize this may be completely wrong but any help is appreciated.


Screen Shot 2022-10-10 at 4.39.15 PM.pngaggregator.displayformat=double
aggregator.function=SUM
aggregator.valuefield=Utilization Percentage
aggregator.valueformat=doubleAsDouble
displayname=Utilization Percentage
textmode=true
valueexpression=DIV({hours},35)
valuefield=Utilization Percentage
valueformat=double
width=65

0 Replies

The ultimate experience is back.

Join us in Vegas to build skills, learn from the world's top brands, and be inspired.

Register Now