AnsweredAssumed Answered

Summing Two Separate Parts on a Report

Question asked by pademo57 on Nov 21, 2016
Latest reply on Nov 26, 2016 by pademo57

I set up a program that tracks the events in a hockey game by pressing a button for each event and puts it into a portal which also shows the time of the event.

My Tables: Hockey_Game::__pk_HID->Hockey_Action::_fk_HID

 

An example would be in the Hockey_Action Table:

Period   Team    Event Time

Period 1 Team 1 Shot   01:54

Period 1 Team 2 Goal   17:14

Period 2 Team 1 Offside 03:01

etc.

 

Because I separated the events Shot and Goal when it comes time to summarize the events by period it separates Goals from Shots.

 

So my question is when creating a report is there a way to combine or add two events and show them as one?

 

In other words, if I have 5 shots and 1 Goal in Period 1, how would I show Shots + Goals for a particular Period, and then at the end of the report also have a combined Shots + Goals? Or is there a better way to do this?

 

I'm sure this is easy, but for a newbie like myself I can't seem to wrap my head around on how to do it.

Outcomes