Percentage Difference Between Two Numbers

[marius]

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

Thank you!

[telaholcomb]

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:

[marius]

@marius

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

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]

Hey @marius, this should do the trick.

[cmarchan]

@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!

[telaholcomb]

Oh! I missed the fact that you said difference!

[marius]

@Eli always knows the way! thank you so much for your help once again!

[marius]

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

[Siddhartha]

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.

[kurgat1.kipkoech]

cool solution for calculations in bubble

[asm1]

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