Account Schedule - Absolute Value

SYLV1G

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

DaveT

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.

Hope this helps