Hey Everyone,
I am looking for suggestions for how to best accumulate hours within the configurator. The base hours for an operation on the parent job is 8 hrs. When we add a particular option it increases the operation by 2 hrs (Accum = 10 hrs). When we add another option, an additional 1 hr is added (Accum = 11 hrs). What is the best way to add these hours as options are selected?
To complicate this further, some options span multiple operations.
Thank you,
Bruce B.
I create hidden fields and use them for my calculations throughout. There are global fields you can create, but I never got them to work how I expected them to.
Brenda J. Mohr
Humtown Products
I don’t know what version you are using, but I checked with one of my product configurator consultants, and got this reply: You would create a PcLookupTable (if using E10) with the option code in one column and the operation hours in another. If user needs to see the hours for each option, then add a greyed out field next to each option to store the hours. Then add an on-leave expression to each option that contributes to the hours and that expression will lookup the hours from the table, place it in the field next to the option and sum the quantities to the total hours field that always in includes the base 8 hours.
If on E9 the options hours could be accessed via .csv table. The hours could also be stored in a standard user-defined (UD) table or a special table called PcConData used for configurators. If the user does not need to see the hours by each option, then the expression will change to test each option and perform multiple look ups and total. Either way the result would then feed a rule on the operation where the hours would be converted in to the Production Standard.
I hope this helps.
Thank you for the suggestions. I am going to looking into the PcConData route. Much appreciated.