Is it possible to use brackets in a calculation?

[waynesilbs]

eg. Let’s say you wanted to express the progress of the month as a percentage of completion…

The calculation would be (Current Date - Month Start) / (Month End - Month Start).

[NicolasDap]

Edit more complex expressions

Any way to add parentheses? See screenshot, I have a star rating icon that needs to calculate the average of some ratings, so I need to add them and divide by 4. If I can’t use parentheses, can I edit the expression by hand to add a /4 to each item? If I try to do now for the first item in the addition, it removes the rest of the expression. Maybe I can do some trick by copy-pasting the parts of the expression from start to end to some other temporary controls to hold, but still it is tiring t…

:filtered without intersect

Hello, I wonder how I can do this. Let’s say I want to display in the same Repeating Group all the blue items from a BrandA AND all the red items from a BrandB. My data source is BrandA’s List of Items :filtered(color=blue) MERGED WITH BrandB’s List of Items :filtered(color=red). However the last “:filtered” filters the whole expression like if it was [ BrandA’s List of Items:filtered(color=blue) MERGED WITH BrandB’s List of Items] :filtered(color=red). So the result gives only the red i…

Order of operations

Does Bubble follow the standard mathematical order of operations. For example, will this divide input 2’s value by 5 and take that away from input ones value, or does it work left to right. If it’s the later, how to I adjust the operation when setting a variable (thing). Input 1’s value – input 2’s value / 5

[waynesilbs]

Will take a look at these - thanks!

[birbilis]

The only viable solution I’ve found is to calculate subexpressions separately and keep them in the database (or in a hidden control if it’s in the same form you need them) and then use them to calculate say the division

Order of calculation is left to right with no operator precedence and no parentheses. It’s like having a single accumulator and various operations involving the accumulator and an operand

e.g.
5+6*3 is
5 = 5
5 +6 = 11
11 *3 = 33

and not 5+18=23

[birbilis]

oops, fixed the original miscalculations (due to late hours probably)

[philippe1]

That’s a bit crazy for such a simple thing

[grace.hong]

Hi all - We recently released an experimental features UI that has a development version of parentheses. Learn more here! Hope you all have the opportunity to start playing around with it and help us iterate to make it better!