Account Schedule - Absolute Value

SYLV1G
SYLV1G Member Posts: 93
edited 2008-04-22 in NAV/Navision Classic Client
Hello

I would like to calculate the absolute value of a column in an account schedule but i don't know if it possible.

Thanks in advance

Comments

  • DaveT
    DaveT Member Posts: 1,039
    Hi,

    This will solve this for you. Mark the colunm you want as an absolute as column no. "A", then create a new colunm which is a formula of (A*A)^0.5

    i.e. the squareroot of the square hence removing the minus. :wink:

    Hope this helps
    Dave Treanor

    Dynamics Nav Add-ons
    http://www.simplydynamics.ie/Addons.html

Categories