Math with fields from different records

[MpWiedemann]

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

[one09jason]

Can anyone tell me, how do I do math with fields from different records? For example:

field B, record 1 = field A, record 1 + field A, record 2

Thanks