Sum of a Report (1 Viewer)

Cubsm22p

Registered User.
Local time
Today, 03:47
Joined
Feb 14, 2018
Messages
37
I would like to count just the total of 'JL' in each row. right now i can only to get it to sum the total. Any help would be appreciated.
rpthelp1.PNG prthelp2.PNG
 

theDBguy

I’m here to help
Staff member
Local time
Today, 03:47
Joined
Oct 29, 2018
Messages
21,358
Hi. Just a guess but if you're using something like =Sum([FieldName]), then try something like this: =Sum(IIf([Job Type]="JL",[FieldName],0))
 

Cubsm22p

Registered User.
Local time
Today, 03:47
Joined
Feb 14, 2018
Messages
37
What would i put as a field name in After the IF True statement i just want to count all the JL in that row in the report


=Count(IF([Job Type]="JL"),COUNT,DoNothing)
Or
=IF([Job Type]="JL"),COUNT,DoNothing)
 

theDBguy

I’m here to help
Staff member
Local time
Today, 03:47
Joined
Oct 29, 2018
Messages
21,358
What would i put as a field name in After the IF True statement i just want to count all the JL in that row in the report
Hi. I'm not sure either because the image you posted seems to be cut off at the right side to see what you're trying to total. What is the Control Source you're using now to do the total? I gave you what I thought it was. Maybe you can show us what you're actually using.
 

Cubsm22p

Registered User.
Local time
Today, 03:47
Joined
Feb 14, 2018
Messages
37
rpthelp4.PNG
rpthelp5.PNG

But i want to just count the records with [Job Type] 'JL' not all the the records
 

theDBguy

I’m here to help
Staff member
Local time
Today, 03:47
Joined
Oct 29, 2018
Messages
21,358
Hi. Okay. Thanks for the additional information. I read counting as different from totalling. Try this: =Sum(IIf([Job Type]="JL",1,0))
 

Cubsm22p

Registered User.
Local time
Today, 03:47
Joined
Feb 14, 2018
Messages
37
Thanks that works , how would i count the total if i want 'JL' and 'JLS' totaled.
 

theDBguy

I’m here to help
Staff member
Local time
Today, 03:47
Joined
Oct 29, 2018
Messages
21,358
Hi. Again, I tend to get confused when you use count and total at the same time. They mean different things to me. Can you post an example of what you mean? Thanks.
 

Cubsm22p

Registered User.
Local time
Today, 03:47
Joined
Feb 14, 2018
Messages
37
=Sum(IIf([Job Type]="JL" or "JLS",1,0))

something like that
 

theDBguy

I’m here to help
Staff member
Local time
Today, 03:47
Joined
Oct 29, 2018
Messages
21,358
Okay. For something like that, you could try: =Sum(IIf([Job Type]="JL" OR [Job Type]="JLS",1,0))
 

theDBguy

I’m here to help
Staff member
Local time
Today, 03:47
Joined
Oct 29, 2018
Messages
21,358
Hi. You're welcome. We're happy to assist. Good luck with your project.
 

Users who are viewing this thread

Top Bottom