Need numerical data from one form, count from another form, to provide a "Total"
I have a form "Events" used for training and outreach scheduling. There is a field "Total Scheduled Event Hours".
I have a second form "Registered Attendees" with a
Decision Field "Attended". (This field was added to swiftly identify the number of actual attendees from the list of registered attendees.)
I have a third form "Trainings"
- with a Lookup Field "Event_Title" that retrieves event title, total scheduled event hours, training topics, and training method (Training_Title, Total_Scheduled_Event_Hours, Event_Purpose, Method_of_Training)
- with a Formula Field "# Attended" - This needs to be a count from the second form or report, "Registered Attendees", with the Decision Field "Attended" value "True" Problem #1
- with a Formula Field "Ttl Training Hours" - This needs to be the product of "Total Scheduled Event Hours" and "# Attended" Problem #2
Thank you!