0

Format numbers when printing

Hi and good day!
I am having a big trouble when printing number results in Ninox which is creating a very long line of numbers after the comma.

Can anyone help on how to format the results, say to show only 02 characters after the comma?

See screenshot herein:

Screen Shot 2021-10-06 at 11.31.03

 

Thanks in advance!!!

Pedro

4 replies

null
    • Fred
    • 2 yrs ago
    • Reported - view

    If your pressure field is a formula field then put this in:

     

    round([formula],2)

    • Pedro
    • 2 yrs ago
    • Reported - view

    Hi Fred, good day!
    I'm sure your formula is right but I may be doing something wrong, because it says function not defined.
    Can you help, please?
    Thanks,
    Pedro

     

    Screen Shot 2021-10-08 at 14.36.26

    • Fred
    • 2 yrs ago
    • Reported - view

    Sorry, change the [] to () and it should work.

    • Pedro
    • 2 yrs ago
    • Reported - view

    Hi Fred,

    It works fine!!
    I did as you instructed; formula was changed to:

    round((PressureKpa / 100 + PressureKpa / 100 * 8 / 100),2)

    Thank you very much!!!
    Pedro

Content aside

  • 2 yrs agoLast active
  • 4Replies
  • 253Views