I need a formula to get only the fractional part of a given number. It should take any number and return its fractional part which is between 0 and 0.9999... For example
123.456 -> 0.456 0 -> 0 1 -> 0 0.1 -> 0.1
I tried google help, but did not find such a function.
I could use something like this, but I did not want to repeat the input expression:
X - FLOOR(X)