Jump to content

calculating across portals


susan
 Share

This topic is 7247 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

This topic is 7247 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.