Services Plugins FAQs

Calculation on sum of field Data Table / Grid

Plugins
#1

Hey there

Im summing values using Data Table / Grid and want to perform a math function on the result of the list of items. I want to convert from minutes to hours as a decimal

In the example site I change this to a text element but Bubble treats this as a list even though I’m summing the list eg

image
image775×585 75.9 KB

I then tried to format it like the calculated fields but get the following error

image
image1156×494 70.7 KB

Any suggestions on how to approach this?

#2

Hey @johnnyweb ,

Thanks for reaching out! :pray:

I see what you’re trying to do — you want to sum the “ShiftLength” in minutes and then convert that to hours as a decimal. The issue you’re facing is because Bubble is treating your sum as a list, even though you’ve done the aggregation.

Here’s a way to fix it:

  1. Change the Data Type of Column 4 to “number”:
  • This is the first step. Right now, you have it set to “text,” but since you’re working with numbers (converting minutes to hours), it needs to be set to “number.” This will allow Bubble to treat the result properly.
  1. Update the Data Source for Column 4:
  • For the data source, instead of just summing the “ShiftLength” and formatting it as text, try this:
Search for Shifts grouped by Employees sum of ShiftLength divided by 60
  • This will sum the “ShiftLength” values (in minutes) and then divide the total by 60 to convert it into hours.

Why This Works:

  • Dividing the summed minutes by 60 converts them into decimal hours, and using “number” as the data type ensures Bubble treats the result as a numeric value instead of a string. That way, you won’t get the error about needing a list of texts.

To Summarize:

  • Column 4’s Data Type: Change it to number.
  • Column 4’s Data Source: Set it to the sum of “ShiftLength” divided by 60.

This should do the trick and display the hours as decimals (e.g., 480 minutes becomes 8.00 hours).

If you’re still having issues or need further help, feel free to drop a message!

Cheers!
Support Team
Browse all Zeroqode Plugins for bubble
Banner_Last3