Hi Frank,
In product configurator I have user input fields of ID, OD & Height. From this the cross section is calculated((OD-ID)/2) - CSInch. From there I need to select an o-ring cross section(ORCS) based on the ID a & Height & cross section so if height
is okay I need to drill down to an available cross section of the o-ring based on the equipment cross section((OD-ID)/2). For example available o-ring cross sections vs minimum heights are .070(>=.186-<.309), .103(>=.309-<.372), &.139(>=.372-<.493).
So for a given ID size I need to find the available o-ring cross section. I have not included the allowable heights below.
Our current code looks like;
If ID >=2.000 & ID < 5.000
{If CSInch >=.372 & CSInch < .493, ORCS = .139
else if CSInch >= .309 & CSInch < .372, ORCS = .103
else if CSInch >= .186 & CSInch < .309, ORCS = .070
else ORCS = 0. }
It seems in the AX2012 product configurator model I can only do chained if-then statements(In calculations) which does not allow the logic to follow through based on the conditions.
Let me know if you need more info. Thanks for the help
