R&R checklist

[leibyj]

I am trying to create a checklist in R&R version 9. This checklist will run several UDF^s and display an error if any one of them does not match the requirements specified. I would prefer not to have a seperate field for each UDF, but a dynamic checklist that will only display text if if something is wrong.____Thank you

[kfleming]

Can you create a calculation that uses a set of nested IIF() statements to check each UDF?____Kathleen__R&R Support

[leibyj]

The problem with nested if statements is it will only give one response. If anything is wrong in the checklist, in needs to be displayed, not just one thing.

[Alan_Klein]

You could create an IIF for each condition, with the "true" value being "1" and the false being "0". I place each in quotes because you could then concatenate them all into what would end up being a binary number, for example, "0010101". Each binary number would uniquely yield the combination of error conditions that were found and which were not found and you could create the error messages which you want to display from that.____Would that work?