I'm trying to use text from a second related field to define the calculation that determines if the data entered into the first field is valid.

For some reason I can't get the text to correctly evaluate as an actual calculation. It just seems to show up as text and not evaluate as a calculation....I know this is super simple, but I'm totally stumped at the moment and I'm hoping to figure this out ASAP. Does anyone have any suggestions on how to get this to work? I've tried using evaluate() but I think I'm setting the syntax wrong.

I currently have the "validate by calculation" box checked and the calculation looks like this:If(Evaluate(Substitute ( YYY10_Measure Item Validation Rules::Validation Calculation ; "X" ; GetFieldName(YYY9_Raw Results::Raw Result) )); 1; 0)

I've also tried using the following to no avail

If(Evaluate(Substitute ( YYY10_Measure Item Validation Rules::Validation Calculation ; "X" ; GetField(YYY9_Raw Results::Raw Result) )); 1; 0)If(Evaluate(Substitute ( YYY10_Measure Item Validation Rules::Validation Calculation ; "X" ; YYY9_Raw Results::Raw Result )); 1; 0)

YYY10_Measure Item Validation Rule = 5<X<10

I've tried using the Let() function, but I can't get the syntax right

Please explain what the actual validation rule is. Reading a cryptic formula (which you say doesn't work anyway) is not helpful.

Please explain what the actual validation rule is. Reading a cryptic formula (which you say doesn't work anyway) is not helpful.

sorry, the actual validation rule in this case is the value must be greater than 5 but less than 10. I wrote this as 5<X<10 where "X" is the contents of the field in question (Raw Result)

And why must this rule be stored as text in a related record (related how?)?

The calculation you want is:

X > 5 AND X < 10

The calculation you want is:

X > 5 AND X < 10

Yep that it did it! thanks a ton!

I'm exploring an EAV style scheme and I want to still be able to enforce validation rules defined in a "validation calculations" table that each of the records is related to