0

Absolute

The Ninox manual says, "absolute( x ) calculates the absolute amount of x, that is, x without a sign.

Example: absolute( -10 ) = absolute( 10 ) = 10."

I'm trying  to use "absolute" in a formula and get the message, "Function is not defined."

Formula's very simple: absolute(x - y), where x and y are number fields.

I've also tried absolute(-12), just to check it's working, and get the same error.

What am i missing?

2 replies

null
    • Database Consultant
    • Kirkness_Associates_Ju
    • 4 yrs ago
    • Reported - view

    Hi Rico

    The function is actually abs(x) - not absolute.

    Keep this page of the manual bookmarked:

    https://ninoxdb.de/en/manual/calculations/reference-of-functions-and-language

    (I always do!)

    • Rico
    • 4 yrs ago
    • Reported - view

    Thank you, Julian. I thought i tried abs, but i must've got mixed up along the way.

    I'll take the link you gave as the final word in future. I was aware of it, but i thought other pages in the manual would be ok too.

    My mistake. The following page not only conflicts with it on abs(olute): https://ninoxdb.de/en/manual/calculations/mathematical-functions , but also round up (ceil) and round down (floor).

    Who knows what other conflicting information it contains?

Login to reply

Content aside

  • 4 yrs agoLast active
  • 2Replies
  • 1181Views