AnsweredAssumed Answered

Summarize a field across multiple rows of a single row portal...

Question asked by GeoffreyMartin on Feb 2, 2013
Latest reply on Feb 4, 2013 by philmodjunk

Title

Summarize a field across multiple rows of a single row portal...

Post

     I have a list view with single row portal contains information from a large table.  I have set each row to be the most current status of an ambulance as of a date_time at the top of the screen.  Each row has a calculation that based on the status returns a 1 or a 0.  I would like to count or summarize this data to get a count of ones an zeros for the entire page.  I've tried a a calculation in the parent table to sum the child table values, but it returns the sum of all of the 1/0 for that unit, not the list.  Is there a way to summarize a field across multiple rows?

      

UH_screen.jpg

Outcomes