I have not been able to find the answer in the help section, or through general testing. I am trying to enforce the requirement of a decimal point in a variable analysis entry. We are currently using IFS Apps 10 UPD 22
As an example: If the nominal value is 90.5, Outer Min is 90.0, and Outer Max is 91.0, is there any way to force the operator to report the measurement to at least 1 decimal place?
The fields appear to be basic numerical entry fields and I do not see any settings for variable that allow you to specific to a certain decimal place.
I am not sure if this functionality exists or not, but I am hoping for some guidance. Thank you.
Best answer by WyrDavidB
I don’t have direct experience of trying to force users to enter a certain number of decimals in a control plan result - but from what you have described and given Richard’s input, creating an event and event action using sql to check the number of decimals in the result and preventing the save if there is not enough accuracy/precision could achieve the result you are looking for.
Depending on the complexity of the control plans used, you might be able to restrict the event so it only fires on certain control plan results, or control plan parts. Alternatively you could do similar at the action level, or use the sql to identify the precision of the nominal value and only allow the save of the result if the number of decimals is the same or greater than the nominal.
I’m not sure if this helps, but if you express the Nominal Value, Outer Min and Outer Max to multiple decimal places (e.g., 90.000) the system can then display the analysis value to the same number of decimal places.
@Richard Owen Thank you for the response. Unfortunately that will not work. We are using that approach, but users are not inputting the correct value to the required decimal point.
I don’t have direct experience of trying to force users to enter a certain number of decimals in a control plan result - but from what you have described and given Richard’s input, creating an event and event action using sql to check the number of decimals in the result and preventing the save if there is not enough accuracy/precision could achieve the result you are looking for.
Depending on the complexity of the control plans used, you might be able to restrict the event so it only fires on certain control plan results, or control plan parts. Alternatively you could do similar at the action level, or use the sql to identify the precision of the nominal value and only allow the save of the result if the number of decimals is the same or greater than the nominal.
Thanks, @WyrDavidB I was thinking about an event to evaluate it. However, there are numerous scenarios where it would not require a decimal for the variable result and my concern is creating a very tedious and manual process to achieve the desired results. This does answer my question, as there does not appear to be a native function (outside of a custom event) to enforce a specific numerical format. Thank you.
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.
