Page 1 of 1
R&R checklist
Posted: Fri Oct 07, 2005 11:28 am
by 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
=> RE: R&R checklist
Posted: Fri Oct 07, 2005 2:01 pm
by kfleming
Can you create a calculation that uses a set of nested IIF() statements to check each UDF?____Kathleen__R&R Support
==> RE: R&R checklist
Posted: Fri Oct 07, 2005 2:28 pm
by 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.
===> RE: R&R checklist
Posted: Mon Oct 10, 2005 10:13 pm
by 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?