Need help w/query

[ET]

In my query I have an expression : Ret MM: Sum((IIf
([ENROLLMENT ADJ AMOUNT]<>10,1,0)*Sgn([ENROLLMENT ADJ
AMOUNT]))).

How do I make [ENROLLMENT ADJ AMOUNT] in the first part of
the expression an absolute value?

Thanks!

 

[John Vinson]

How do I make [ENROLLMENT ADJ AMOUNT] in the first part of
the expression an absolute value?

With

Abs([ENROLLMENT ADJ AMOUNT])

 

[ET]

Thanks

-----Original Message-----

How do I make [ENROLLMENT ADJ AMOUNT] in the first part of
the expression an absolute value?

With

Abs([ENROLLMENT ADJ AMOUNT])



.