Excluding Items in a Report

[cooh23]

Hello All,

I have a report that shows the individual stats as well as the individual stats compared to other members.

What I would like to do is to separate their total time by Production and Non-Production.

I get the total of both production and nonproduction by:

=Sum([TotalTime])

To determine whether prod or non-prod, i have a field called "FunctionType"

Can I do something like:

=Sum([TotalTime], [FunctionType]<>"Non-Production")

The reason i want to exclude "Non-production" is because i have about 50+ functions that are production and non-production combined.

Please help.

THank you,

 

[pbaldy]

Try

=Sum(IIf([FunctionType]<>"Non-Production", [TotalTime], 0))

 

[cooh23]

Try

=Sum(IIf([FunctionType]<>"Non-Production", [TotalTime], 0))

Thank you very much it works great!

Could you look at this thread too? This??

Sorry to take advantage of this. It's because i am still working on the problem i posted in that link.. i'm thinking it's possible but maybe it isn't?

Thank you again.