The order of operations (+ and *) is not respected in a form Input

spa.sc · 2025-04-02T19:44:46.502Z

I have a table of Services performed and an option set of Service Type. Performed services are billed according to the time spent and their type unit price. For example a Hair Cut is billed 20$/h and a Nail Design 15$/h.

When I display a table with all performed services, and I need to calculate the total for all services. For that I use a form input with the following formula in the Input field:
Sum of hours of Hair Cut x Unit Price of Hair Cut + Sum of hours of Nail Design x Unit Price of Nail Design

But Bubble doesn’t respect the normal order of calculation. It does:
((Sum of hours of Hair Cut x Unit Price of Hair Cut) + Sum of hours of Nail Design) x Unit Price of Nail Design

Example:
I did 3 hours of Hair Cut, and 3 of Nail Design
Unit Price of Hair Cut is 20$, and of Nail Design is 15$
So total should be 3 x 20 + 3 x 15 = 105$
But for Bubble it’s ((3x 20) + 3) x 15 = 945$

See print screen.

Captura de Tela 2025-04-02 às 16.39.021047×610 10.6 KB

Captura de Tela 2025-04-02 às 16.46.15868×610 68.7 KB

georgecollier · 2025-04-02T19:47:37.011Z

Bubble calculates from left to right, unless you enable the parentheses feature in Settings → Versions → Experimental features

spa.sc · 2025-04-02T22:03:11.779Z

This is the solution. But the editor is really tricky to use. Thanks

bodiebloore · 2025-04-03T01:53:42.512Z

I have also found using “arbitrary text converted to number” works great as an easy way to divide complex formulas, makes it easier to edit down the line as well

spa.sc · 2025-04-03T16:24:17.533Z

Thanks for the tip.

system · 2025-04-16T19:45:00.584Z

This topic was automatically closed after 14 days. New replies are no longer allowed.