How to ROUND a number to more digits?

  • Resolved ricchezza

    (@ricchezza)


    7 years, 1 month ago

    Hey guys! I am making a pretty complex form today and one more question:

    I have a calculated field that gives me a 30% part from another field. But i need it to be ROUNDED to thousands. For example i have 30945 number and 30% of that is 9283. Can i force the field to show 10000 instead of 9283? Thank you so much again!

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author codepeople

    (@codepeople)

    Hello @ricchezza,

    Your question is not about the plugin, it is pure mathematics, if you want round the result to the next multiple thousands, the operation would be:

    CEIL(x/1000)*1000

    CEIL(X) returns the integer number greater than or equal to X

    For example, using the number you use in the ticket:

    CEIL(9283/1000)*1000 = CEIL(9.283)*1000 = 10*1000 = 10000

    Best regards.

    Thread Starter ricchezza

    (@ricchezza)

    great! it works!)) thank you so much!

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘How to ROUND a number to more digits?’ is closed to new replies.