000033627 - RSA Archer 5.x Calculated field error occurs: The formula will result in a circular field reference that cannot be resolved. Use the formula builder to get details on the complete path of the circle

Document created by RSA Customer Support Employee on Jul 29, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000033627
Applies ToRSA Product Set: Archer
RSA Product/Service Type: Archer
RSA Version/Condition: 5.x
IssueWhen adding or updating a calculated field or formula, an error/warning occurs:
The formula will result in a circular field reference that 
cannot be resolved. Use the formula builder to get details
on the complete path of the circle.


User-added image
CauseCircular references are caused by formulas that form either a direct or indirect loop.
  • A direct loop is formed when a series of field references form a closed circuit.
  • An indirect loop can sometimes result when a series of field references includes a reference to a field that is set to Always recalculate.
The RSA Archer GRC does not allow formulas that might result in circular references. Whenever a possible circular reference condition exists, a validation message is displayed. 
For more examples and details, check out the Circular References section in the Archer Help located at: Application Builder > Manage Applications > Managing Calculations > Circular References.
ResolutionChange a calculated field's Recalculation option from Always to As Needed for one of the referenced calculated fields.
User-added image

Attachments

    Outcomes