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

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