HI, so i need to round numbers up to the nearest full integer. So for instance if my number is 1.2 it has to round up to 2. But i noticed that with the “round” formula it rounds down to the nearest integer which would be 1. But in my use case this would lead to wrong calculations. Is there a way to…

Math.ceil(1.2) [image] Math.ceil() - JavaScript | MDN The Math.ceil() static method always rounds up and returns the smaller integer greater than or equal to a given number.

Thanks Dorilama, i was hoping i could be done with formulas from weweb themselves. This looks easy enough to do, i’ll try this.

I’d love rounddown and roundup formulae within WeWeb, too. I need to round the results of a complex formula.

Using Math.ceil works just fine in the formula view - and doesn’t particularly add complexity or unreadability to the result. All weweb formulas are wrappers for javascript functions, and they do their jobs best when they are focused on weweb-specific concerns and let the easy parts of JS do their j…

Nice, thanks! I didn’t know they could be combined like that. Would I need to write a custom JS formula to round up to the nearest 10 or 100 instead of the nearest integer?

I would just do (for rounding to the nearest 10) Math.round([myvalue]/10)*10 In the above, 993 would become 990

Thanks, Ray - much appreciated! I saw your business through your profile, too - awesome idea. I can see that being helpful to many.

Interesting, does that mean that we can use javascript functions in the formula field?

Yes, formula are javascript expression, any valid js will work :slight_smile:

Awesome! Can we use arrow functions? Then we would have access to some of the array functions like reduce, map etc which would be incrediby powerfull.

Math formula to round numbers to ceiling

Ask us anything How do I?

dorilama (Mariano) March 11, 2023, 11:05pm 2

Math.ceil(1.2)

1 Like

Topic		Replies	Views
What are your favorite examples of no-code formulas in WeWeb? Share your work formulas , binding	16	1606	May 18, 2023
[Request?] Min and Max in Formulas Ask us anything formulas	2	258	February 24, 2024
Displaying currency format on a table/grid Ask us anything design , xano	4	936	September 13, 2023
Convert Number to Words Ask us anything	7	368	August 11, 2023
Having difficulty showing two decimal places in text formulas. Bug? Ask us anything	5	583	September 20, 2023

Math formula to round numbers to ceiling

Related topics