000033229 - From the Formula Builder window in RSA Archer, a Validation error occurs: Too many parameters are specified for IF function

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support on Apr 11, 2019
Version 4Show Document
  • View in full screen mode

Article Content

Article Number000033229
Applies ToRSA Product Set: Archer
RSA Version/Condition: All
IssueCalculations formula error when more than 64 IF functions are used.

Too many parameters are specified for IF function.

CauseRSA Archer has an arbitrary limit on the number of IF clauses that you can have in one calculation field. This is to prevent the .NET application pool in IIS from crashing if it exceeds a certain memory threshold, max number of 'IF' statements or clauses are 64. 
ResolutionBreak up the calculation's formula into separate calculations in some logical fashion. Then have a final calculation that logically combines them back together for the desired solution.