0

How to make round down work

Hi!
In manual it looks like round down(x) should work

but it doesn“t

15 replies

null
    • EYELAB
    • Maria
    • 4 yrs ago
    • Reported - view
    • EYELAB
    • Maria
    • 4 yrs ago
    • Reported - view

    And screenshots don“t attach too(

    • Mel_Charles
    • 4 yrs ago
    • Reported - view

    Maria

    Screen shots are broken !! at the moment

    sample ------          round down (“Sell Price”, 2);

    rounds Sell price down 2 decimal places

    round(x) rounds x to nearest whole number

    round up (x) round x up

    round down (x) round x down

    • Mel_Charles
    • 4 yrs ago
    • Reported - view

    PS it  does work - i“m using it all the time (cloud version)

    here is a sample from one of my scripts

    round(”Sell Price“, 2);
    Mkup := (”Sell Price“ - ”Cost Price“) / ”Cost Price“ * 100

    • EYELAB
    • Maria
    • 4 yrs ago
    • Reported - view

    when I use round down(x) it writes - column didn“t found: row 1 column 5 and don”t let save formula

    • EYELAB
    • Maria
    • 4 yrs ago
    • Reported - view

    round(x) works

    • EYELAB
    • Maria
    • 4 yrs ago
    • Reported - view
    • EYELAB
    • Maria
    • 4 yrs ago
    • Reported - view
    • Ninox partner
    • RoSoft_Steven.1
    • 4 yrs ago
    • Reported - view

    use floor(“CYL OD”) instead.

    “round down ” is not a valid syntax in ninox

    Steven

    • Mel_Charles
    • 4 yrs ago
    • Reported - view

    Sorry Maria

    did not mean to confuse you. I have only used round(x) and round up to date and a you say round down is stated as the syntax in the manual. So I assumed that would work too. Good job Steven knows better !!!!! 
    Mel 😊

    • Mel_Charles
    • 4 yrs ago
    • Reported - view

    Sorry Maria

    did not mean to confuse you. I have only used round(x) and round up to date and a you say round down is stated as the syntax in the manual. So I assumed that would work too. Good job Steven knows better !!!!! 
    Mel 😊

    • Ninox partner
    • RoSoft_Steven.1
    • 4 yrs ago
    • Reported - view

    I think Ninox need to update their website, the round up/down syntax is indeed documented in the Mathematical functions section, but I think it was used in previous version of Ninox and is no longer supported. Shoot me if I“m wrong. You can find the most reliable version of the syntax here: https://ninox.com/en/manual/calculations/reference-of-functions-and-language 

    Steven

    • EYELAB
    • Maria
    • 4 yrs ago
    • Reported - view

    Thanks Steven! Floor works)

    • Mel_Charles
    • 4 yrs ago
    • Reported - view

    Steven

    Yes that makes it harder to help someone when the manual is found wanting!

    That links just gives you a 404 error!

    • Ninox partner
    • RoSoft_Steven.1
    • 4 yrs ago
    • Reported - view

    Yes, this forum becomes very sh.tt.

    To go to the link, copy as text and paste it in the browser URL bar.

    Steven.

Content aside

  • 4 yrs agoLast active
  • 15Replies
  • 1014Views