Summing Filtered Portals
I have a grading database, which is comprised of a number of tables that are linked via relationships. I have a table and layout called student summary that has a number of tabs on it. One of the tabs is labeled "final project." In this tab, I have four portals that have been filtered by the stage of the project. The final project table is set up with a minimum amount of fields; category, points, stage, full name, class code, and so on.
I would like to sumarize the grades by stage, but cannot find a way to calculate just the points for stage one. Because the originating table has only one field for points, the calculations for the portals is summing all of the fields labeled final project::Points. I have also created a summary part in another layout associated witht he final project table. This gets me closer, but still does not allow me to show grades by project stage in the student sumary sheet. I was hoping there was a way to use an "if" or "getsummary" statement to accomplish this, but it does not appear to work.
At this point I think the only thing I can do is set up four individual fields in the final project table, one for each stage of the project. This will give me the specificity I need in the portals, and subsequently in the studentt summary layout. Any thoughts?