sum column

  • Thread starter Thread starter JIM.H.
  • Start date Start date
J

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
 
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.
 
Back
Top