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.
Hey @marius, this should do the trick.
6 Likes
@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!
@Eli always knows the way! thank you so much for your help once again!
1 Like
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.