Reports and Basic Arithmetic

[dharma80]

Solution / Reports and Basic Arithmetic

Description: Hi, I have just started learning FileMaker Pro. I started with this basic arithmetic and adding of data into a report. An automated Tally Sheet that sums up 3 numbers and be able to add another record. However, Is there a way to make the program more functional by Entering Records of Candidates with the corresponding list of votes per Room (ie. 100 Rooms), inputs the Date/Time it was recorded and the partial Tally per candidate. I was able to add Candidates and sum up votes per room but in a manual manner. I hope somebody could help me with my problem. Thank you.

Here's a sample of the code i've previously done:

Field:

candidate ID : 001

candidate Name : XXX XXXX

Room1 : 12

Room2 : 10

Room3 : 8

Total : 30

Total=Sum(Rm1,Rm2,Rm3)

* But i tried doing this program manually. How can i store multiple votes (per Room) in a single TextField and Display in Matrix format the Time/Date the vote per Room is encoded and Partial Vote per Candidate?

* What object to use and how, to be able to display a Canvass/Tally per candidate?

Hope you could help me solve this problem. Thank you

Working Under:

Solution Status: Beta

Pre-requisites:

Author(s): dharma80

Date: 03/15/07

Credits:

Instructions / Other Info:

Disclaimer:

FM Forums does not endorse or warrantee these files are fit for any particular purpose. Do not post or distribute files without written approval from the copyright owner. All files are deemed public domain unless otherwise indictated. Please backup every file that you intend to modify.

[mr_vodka]

I think that there should be at least two tables; one for candidate information and the other for votes. You may need a third table for rooms but not knowing your complete setup, I can not comment.

You can then use a summary report or the Sum() function to total the counts for each candidate.