Calculating Various Fields

[CraigB]

I am a little confused on how to do the following.....

I have the following fields:

reservations

price

total_reservations

available_seats

total_seats

income_total

income_needed

payment_received

1 - In the 'total_reservations' field, I would like the sum of all of the 'reservations' fields.

2 - In the 'available_seats' field, I would like the sum of 'total_seats' minus 'total_reservations' field.

3 - In the 'income_total' field, the sum of all 'price' fields.

4 - In the 'income_needed' field, the sum of a set number ($1100.00 for example) minus the 'income_total' field.

5 - A PAID logo to display if the 'payment_received' field is not empty (or does have a value in it).

Any help would be greatly appreciated.

Thanks.

[Tori Mitchell]

I have the following fields:

reservations, price, total_reservations, available_seats, total_seats, income_total, income_needed, payment_received

1 - In the 'total_reservations' field, I would like the sum of all of the 'reservations' fields.

2 - In the 'available_seats' field, I would like the sum of 'total_seats' minus 'total_reservations' field.

3 - In the 'income_total' field, the sum of all 'price' fields.

4 - In the 'income_needed' field, the sum of a set number ($1100.00 for example) minus the 'income_total' field.

5 - A PAID logo to display if the 'payment_received' field is not empty (or does have a value in it).

Whoops. Sounds like you've got a problem there with having too flat an ERD issue. You should elaboarate a little on how you have your tables (there are more than one, ne?) laid out as the kinds of aggregate maths that you're talking about there is generally something that you pull across a relation.

For example, from what you have there, you probably have something that all these reservations go into, right? Also, what are the reservations attributed to? A customer? Hmmmm...

If all of this sounds like what you've got there, awesome, please tell the rest and the fine folk here will likely answer the question fairly quickly. However, please, if what I'm talking about sounds like gibberish, please buy either the SEQ book from Que Press or the FileMaker Pro Bible from Wiley. Both are wonderful introductions to this kinda thing... and for $50 and a little time, you'll save yourself thousands of dollars in hours asking us every question like this... and if you're getting into this, there will be hundreds of those kinds of features.

For what it's worth, depending on your answer, everything that you're asking about up there is simply trivial to implement.

HTH

[CraigB]

I am creating a reservation system for a trip that I am organizing.

I got the values that I needed after playing around with them.

Now one that I cannot fiqure out.

In a dropdown menu I have three pickup locations, Los Angeles, Fullerton, and Oceanside.

In the reports, I have them grouped by location with the Sub-Summary (by pickup location). How do I get the numbers (how many at each location) to print next to the location on the report? I also would like to have a running total on the data entry page of the same numbers. I have tried various calculations, but cannot find the correct one.

Thanks,

Craig

[Fitch]

Put your summary fields on the sub-summary part next to the location field.

For running total you would use a summary field, but select the "running total" checkbox in the field definition.

[CraigB]

Thank you for all of your help. I got it working.