Article Content
Article Number | 000037991 |
Applies To | RSA Product Set: Archer RSA Version/Condition: 6.5.0.4 Platform: Windows |
Issue | The calculated text field contains an error "The row was outside the expected range." when the formula attempts to set the calculated text field to the value in another text field. |
Cause | In the following situation:
|
Resolution | This defect will be addressed in a later release. |
Workaround | In the calculated text field, wrap the IF function in a text processing function that inputs text and outputs text. This forces the value from the text field to remain as a text value so it can be saved into the calculated text field. Example: If the formula is:
Then a formula to resolve the issue is:
Note: The purpose of the PROPER function is to capitalize letters, but it can also be used to force both input and output to be processed as text. |