Sum In A Report

[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

 

[Duane Hookom]

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