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

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

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.