Newbies gjbwalker Posted December 12, 2006 Newbies Share Posted December 12, 2006 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 Link to comment Share on other sites More sharing options...
Genx Posted December 12, 2006 Share Posted December 12, 2006 Yeh, Min ( Field1 ; Field2 ; Field3 ; Field4 ) etc. will return the lowest value... are you sure your structure is sorted though? Link to comment Share on other sites More sharing options...
Newbies gjbwalker Posted December 12, 2006 Author Newbies Share Posted December 12, 2006 Thanks! What do you mean by the structure being sorted? Link to comment Share on other sites More sharing options...
Genx Posted December 12, 2006 Share Posted December 12, 2006 I mean might it not be better placed in a related format? Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6316 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now