Jump to content

Math with fields from different records


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

Recommended Posts

Hi,

What you need to do is define some "self join" type relationships. Think about what pieces of information actually tie the records you want to perform math on together, and then have your calculations "look" through these relationships. Here is a simple example of this:

Take an invoice file that has multipe invoices for a single customer. Let's say you want to count the number of invoices in the system for that customer. What you do is create a relationship to the same file using the customer ID as the key field. (NOTE: Make sure that the relationship is set NOT to create or delete related records!) Next create a calculation field that uses the "Count" funtion and define as follows.

CalcField = Count(RelationshipName::ID Field)

This will give you a count of the related records and will show how you can use related values from the same database in your calculations.

Good luck,

Martin Wiedemann tongue.gif" border="0

Link to comment
Share on other sites

This topic is 7307 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.