sum column

[JIM.H.]

Hello,
In my report I have two columns: Col1, Col2 and in the
footer I have Sum([col1]) and sum([col2]). They look fine,
now what I need something like this (if([col1]<>"xxxx", Sum
([col2])) that means sum col2 while col1 has a value other
than this specific value. How can I do this?
Thanks,
Jim

 

[Duane Hookom]

Try:
=Sum(Abs(Col1<>"xxxx") * Col2)
Col1<>"xxxx" will evaluate to either true/-1 or false/0
Abs() converts the -1 to 1. Multiply this times Col2 results in either Col2
or 0.