|Applies To||RSA Product Set: Archer|
RSA Version/Condition: 5.x
|Issue||Calculations formula error when more than 64 IF functions are used.|
Too many parameters are specified for IF function.
|Cause||RSA 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.|
|Resolution||Break 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.|