Finding the lowest number

[gjbwalker]

I am a beginning FM Pro user working for a manufacturing company.

I am trying to create a calculation that shows how many assemblies are available based on the number of parts that are in inventory.

Ex: 1 assembly has 4 parts using 1 part each.

Parts in inventory (each part is a number field in FM)

part 1--qty 5

part 2--qty 17

part 3--qty 10

part 4--qty 20

Obviously, 5 assemblies are available because the lowest part qty is 5.

Does anyone have any suggestions as to a calculation I can use to display that lowest number?

Thanks,

Greg

[Genx]

Yeh, Min ( Field1 ; Field2 ; Field3 ; Field4 ) etc. will return the lowest value... are you sure your structure is sorted though?

[gjbwalker]

Thanks!

What do you mean by the structure being sorted?

[Genx]

I mean might it not be better placed in a related format?