Order of operations

Questions
22

Still no parenthesis? Can’t calculate a simple VAT sum :pensive:

1 Like
23

So my work around to missing PEMDAS is to calculate what would be in parenthesis in separate disabled input fields:

Here and example of Value A + Value B + Value C, where Value C is (Value B * 0.07). I tried using text fields but they wouldn’t have it. I haven’t finished building my shopping cart yet, but I’m assuming it would be beneficial to have input fields anyway, so I can create a new order item.

image
image1920×1080 389 KB

1 Like
24

Anybody interested you can use the Formulize plugin to achieve this and alot more. Basically excel formula in bubble with custom variables

2 Likes
25

Is it done in 2019 ? cant find

26

Nope, not possible yet. You could probably use a plugin for it, but it’s not built in to Bubble natively.

27

Bubble team? Is the plan still to add this functionality at some point or is this not even close to a priority?

4 Likes
28

Bubble team, please add paranthesis. They are really necessary for a variaty of backend conditional statements!

4 Likes
29

I haven’t used this yet, but does the api for math.js give you this functionality? I could be wrong though. But yes native would be best.

30

Yeah, and even doing it in 2 steps with a custom state is painful as an expression like “1-{data}” cant be entered …

Calculating a margin or a VAT takes way longer and way too many hacks than it should.

1 Like
31

Try {data} x -1 + 1

Because there are no order of operations, you can do these types of workarounds in a single step.

32

I had divisions after that, but my workaround was {data}*0+1-{data}

33

Bump.

1 Like
34

Newbie here…
I haven’t been able to figure out workaround described in this chain. Can someone explain slowly for a newbie? :slight_smile:
I have created a 1st app that helps figure out cost to produce and price a new consumer good. Struggling with some simple math:

  1. User enters price
  2. App calculates Cost of Goods Sold (COGS) based on users other inputs (sum of labor, materials, etc)
  3. App accurately calculates GM (Price - COGS) and presents as GM$
  4. Can’t get it to calculate GM% which is GM$/Price, or: (price-cogs)/Price…can’t figure out how to put parenthesis in equation or otherwise mimic parenthesis via some type of workflow.
    Here’s a screen print:
    image
    image2670×1299 240 KB

    appreciate the help, al
35

“no-coding with JS” - Bubble
Great!

36

Jesus, this feature is crucial! Just develop it ASAP ,please!

6 Likes
37

It works left to right, not order of operations. I’ve realized that while creating my app. A way to work around it is to run a workflow for the part you want calculated first, store that value, and then create another workflow segment for the second part, etc.

38

Also very surprised parentheses not possible - seems very basic - just adding my +1 for this feature to be added

3 Likes
39

You have brackets in the Expression builder (Toolbox plugin) if you really need them. Which you usually don’t.

5 Likes
40

Great thanks @NigelG for the reply :slight_smile:

41

Expression plugin works great! A little weird that I have to create an element in the builder for each impression. It’s still better to have a native parentheses feature.

1 Like