Does anyone know how I can calculate the percentage difference between two numbers like you would in a spreadsheet.

Thank you!

Does anyone know how I can calculate the percentage difference between two numbers like you would in a spreadsheet.

Thank you!

1 Like

Hi @marius!

⠀⠀⠀

You can accomplish this by

⠀⠀⠀

*first input or search criteria:count / second input or search criteria:count :formatted as %*

⠀⠀⠀

Here’s an example of how I did it in one of our apps:

Thank you @telaholcomb

I tried dividing the two numbers, but in my case that does not work.

21/17= 1.235

In my spreadsheet I’m doing (17-21)/21 = -0.19. Which is the correct answer…

So I need to be able to do (17-21)/21 in Bubble somehow.

@eli I think you nailed it! Exploring further `:format as text`

could enable many folks to deal with more and different situations in Bubble … with calcs being one of them.

I for one will start learning more about it!

Thanks!

1 Like

Oh! I missed the fact that you said difference!

Oh no problem, thank you so much for taking the time to respond.

Brilliant video Eli. Thanks for that.

The big shame is that Bubble don’t just allow bracketed calculations. It would make it soooooo much easier.

But at least, thanks to you, I should be able to get done what I need to get done Eli.

1 Like

cool solution for calculations in bubble

1 Like

Fortunately, there are plugins that can fix the problem. I always use math.js if I have to do calculations.

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