Navision – How to find out Square Root / Cube Root?

We all know how to raise a number to the power n. Use the powerful nummeric function ‘Power’.NewNumber := POWER(Number, Power);
So Power(4,2) will result in 16.But how to find out the roots (square, cuber or nth root)?

Simple use the same Power function – And just change the ‘Power’ parameter of the function.

So to find out the square root of say 16, use

Power(16,1/2); This will result in 4

to find out the Cube root of say 8, use

Power(16,1/3); This will result in 2.

to find out the nth root of any number just use –

NewNumber := Power(Number,1/n);

2 Replies to “Navision – How to find out Square Root / Cube Root?”


This site uses Akismet to reduce spam. Learn how your comment data is processed.