How to make round down work
Hi!
In manual it looks like round down(x) should work
but it doesn“t
15 replies
-
-
And screenshots don“t attach too(
-
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
-
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 -
when I use round down(x) it writes - column didn“t found: row 1 column 5 and don”t let save formula
-
round(x) works
-
-
screenshot
-
use floor(“CYL OD”) instead.
“round down ” is not a valid syntax in ninox
Steven
-
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 -
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 -
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
-
Thanks Steven! Floor works)
-
Steven
Yes that makes it harder to help someone when the manual is found wanting!
That links just gives you a 404 error!
-
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