How to make some formulas?

Guys, hello.

The question is how to make cascading formulas?
That is, to calculate the total value of the other calculated values?

Can someone send an example, how to implement it?
I do not understand at all ((((

I will be very grateful)

I attach a picture and an example in Excel

https://docs.google.com/spreadsheets/d/1IqrHnkCKO67bxssnJHULW86uhm_2P6NmRUFlE6dDlrU/edit?usp=sharing

1 Like

Somebody, pls)

I tried to do it on the bubble, but nothing comes out.
Those. the first multiplication goes well, and the second is no longer working, the result shows 0. Although it is possible to subtract from the resulting number, add.
What to do? Where is the mistake? Here is a page where the explanation and attempt to make

https://vikatest.bubbleapps.io/version-test/test-calculate?debug_mode=true

This may help:

1 Like

I try this plugin, but i dont understand how use it. Do you have any examples?

I don’t have any examples with complex operations in my apps. But I do have an invoicing system. To give you an idea, here’s how I do simple calculations for a ‘charge’. You’ll of course, reference your own data points and enter the type of calculation you’re looking to achieve.

Apologies as I don’t have much to share.

Tell me, please,can I see the online version?
And if it were possible, it would be just great!

Now I tried with math.js - something seems to be working.

Yeah, boiii, I did it with the math.js plugin.

Confuse 2 points:

  1. If you do through this plugin, then as I understood, it will be difficult to do a lot of fields and calculations.
  2. Is it impossible to do this through standard input functions? So it would be 100 times more convenient and practical!

Glad to hear! Bubble has built in functionality of doing simple calculations. Here I have just a simple input set as an integer, and a text field to display the outcome. So, you could have multiple fields, and set the text field as ‘Input A’s value * Input B’s value / Input C’s value’ etc etc etc.

image

1 Like

Yes, simple and one-time mathematical operations can be done. But, for example, you will not be able to multiply the result of the past multiplication.
That is, Input1 * Input2 you can do - you get value1. But you can’t multiply value1 by input3

You could. Just put a text field that is hidden to reference it:

4 Likes

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