Calculation for Combining Two Number Fields from Separate Tables
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.
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.)