calculating across portals

[susan]

I have a solution with a "grid" made up of 6 portals (one each for grades K through 5) Each row holds the score for a particular test. This works great. (The grid is in a Reports file; the portals show data from a Tests file.)

The next request from my end user...she wants to have it calculate the difference between scores of the same test from year to year. For example, rather than do the math in her head, she wants the solution to display the difference between Test A in 2nd grade with Test A in 1st grade.

Thanks for any help.

Susan

[LiveOak]

You need to build relationships in the main file that will select the appropriate records from the transaction file. These relationships will be based upon compound keys made up of a concatenation of "Test Name" and "Grade". Then the calculation in the mail file will look like:

G1G2TestADiff (calculation, number) =

Rel2::TestScore - Rel1::TestScore

-bd