ignore sign of numbers

[R Subrahmanian]

I have a table with, among others, Fields A and B having
positive numbers. C is a calculated field A minus B. I
require the total of C, ignoring the positive/ negative
sign. (i.e)If, in Record one C = -100 and for record two C
is +75, the total required is 175.

Can I do it using C = (If A > B (A-B); else (B-A).

I tried adding two fields - D = (A-B)squared; and C = SQRT
(D); I couldn't succeed. Perhaps, SQRT function only
supports numbers and not fields.

Can you kindly help me. Thanks for your support.
Subrahmanian

 

[Graeme Richardson]

Hi, try Abs([A]) + Abs()

Cheers, Graeme

 

[Douglas J. Steele]

Try using the Abs function (Absolute value):

C = Abs(A) + Abs(B)