# 12 Seats - max charge of 10

This topic is 6502 days old. Please don't post here. Open a new topic instead.

## Recommended Posts

I am updating a DB for a charity event that keeps track of ticket sales. Here is the challenge.

There are 12 seats per table

Each seat is \$500

Max charge per table is \$5000

Any quantity can be sold. e.g. - 32 seats = (2 tables and 8 seats) charge= 5000+5000+4000

FileMaker Version: 6

Platform: Mac OS X Panther

##### Share on other sites

Sounds like an algebra problem.

Tables = Int(Seats Sold/12)

Table Charge = 5000 * Tables

Seats Remaining = Seats Sold - (Tables*12)

Seats Remaining Charge = Seats * 400

Total Charge = Table Charge + Seats Remaining Charge

##### Share on other sites

I quickly built your formula, but it seems something is missing (or I have messed up). see attached

seats.zip

##### Share on other sites

Hi rivet,

To accomplish the outcome you are looking for in a single step, you may wish to use the formula:

Int(sold/12) * 5000 + Min(10, Mod(sold, 12)) * 500

Attached is a revised copy of your test file which includes the above formula and also has relevant corrections to the formulae which you were using to calculate the individual steps.

seats.zip

##### Share on other sites

Hi Ray, in looking at your formula with regards to the min function, I was not aware that you could use direct entry numbers in the min function. In looking at the formula above I would have expected to get an error upon entry stating that 10 was not a valid field. The way the help explanation reads only field names are allowed in the Min function. Is this another undocumented feature or am I interpreting something wrong concerning min?

Rod

##### Share on other sites

Hi Rod,

The Min( ) function can be applied to any series of entities that are resolvable numerically, so that can be a series of numbers, of expressions (so long as they produce a numeric result), fields, field repetitions or related records. A mix of numbers, fields and/or expressions is also possible.

This has been the case through many versions (and is still so in version 7), though you woudn't know it from the manuals and the online help documentation. So I guess that yes, it is another undocumented feature... But then, if the documentation provided by FMI were to fully explain all the applications and permutations of every function and feature of FileMaker, they'd need a semi-trailer to deliver the manual.

##### Share on other sites

It seemed right in my head, but thanks for the Min() function, Ray.

##### Share on other sites

This topic is 6502 days old. Please don't post here. Open a new topic instead.

## Create an account

Register a new account