Sum Total in a Report

[scoobypaw]

I am trying to total a status field which is based off a lag time formula which is then turned into a status (Early, on time, late, or pending)

I am trying to calculate how many early, on times, lates, and pendings I have for each quarter.
This is the formula I am using:

=Sum([Status2]="On Time")

It is giving me the right # , however if it is anything other than qty 0 it returns the number as a negative.
So if there are 3 records are are "on time" it returns -3.

What is wrong with my formula ?

Thanks for your help

 

[gol4]

try
=Sum(IIf([Status2]="On Time",1,0))

 

[PHV]

Why not this ?
=Abs(Sum([Status2]="On Time"))

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[RoyVidar]

It's translating it to a boolean expression, where true evaluates to -1, try

[tt]=abs(Sum([Status2]="On Time"))[/tt]

Roy-Vidar

 

[scoobypaw]

IT WORKED !
=abs(Sum([Status2]="On Time"))

I thought I tried that already. Apparently not =

Thanks guys. You are GREAT help