000037991 - RSA Archer calculated text field has error when being set to the value in another text field: The row was outside the expected range.

Document created by RSA Customer Support Employee on Oct 10, 2019
Version 1Show Document
  • View in full screen mode

Article Content

Article Number000037991
Applies ToRSA Product Set: Archer
RSA Version/Condition: 6.5.0.4
Platform: Windows
IssueThe 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.
CauseIn the following situation:
  • Formula in calculated text field references a text field.
  • Formula in calculated text field contains an IF function
  • Value in text field referenced by calculated text field contains a long number with the letter "E"
The calculated text field will have a calculation error stating: The row was outside the expected range. 
ResolutionThis defect will be addressed in a later release.
WorkaroundIn 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:

IF(1>0,REF([Policy Reference(s):],[Policy Name]),REF([Policy Reference(s):],[Policy Name]))


Then a formula to resolve the issue is:

PROPER(IF(1>0,REF([Policy Reference(s):],[Policy Name]),REF([Policy Reference(s):],[Policy Name])))


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.

Attachments

    Outcomes