Sum In A Report

M

Mark Jackson

Hello,

I am trying to sum "Lines Quoted" based on the person's initials that is in
charge of working a particular project. I am using
=Abs(Sum([Lead]="MJ")*[Lines Quoted]) but the total is incorrect. What am I
doing wrong? Any help is appreciated.

Mark
 
D

Duane Hookom

Where is this control located? What's wrong about it? Maybe try:
=Sum(Abs([Lead]="MJ")*[Lines Quoted])
 
Top