AnsweredAssumed Answered

Calculation for Combining Two Number Fields from Separate Tables

Question asked by brianquillin on Aug 2, 2011
Latest reply on Aug 9, 2011 by brianquillin

Title

Calculation for Combining Two Number Fields from Separate Tables

Post

Very basic question but I cannot find a direct answer in any thread.

I am trying to track TOTAL CONTRIBUTIONS for my non-profit organization.

I would like to combine, for each CONTACT, Invoice::invoice_total AND Contributions::contribution_total.

Brief Explanation:

We have contacts (approx 400+) that over a several year period will sponsor various things for a specific dollar amount (which invoices are created for); they will also donate/contribute items to be sold via auction; they will also purchase items at the auction donated by other contacts.

I would also like to create a HISTORY table (if necessary) so that I can create a report by contact that will show their TOTAL CONTRIBUTION for a one year period (I've already found information about sorting the date range).

Lastly, and separate issue: any suggestions on how to have FM PRO 11 generate SPONSOR CATEGORIES based on this TOTAL CONTRIBUTION (ie.  $1 - $99 = Donor; $100 - $249 = Sponsor; $250 - $499 = Angel, etc.)

Outcomes