Sum In A Report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Where is this control located? What's wrong about it? Maybe try:
=Sum(Abs([Lead]="MJ")*[Lines Quoted])
 
Back
Top