Skip to Content
0
Former Member
Mar 05, 2015 at 06:03 PM

Unable to solve missing parenthesis mystery

571 Views

Hello experts.

I am getting a multivalue error on one of my heat map cell. so I am trying to use following formula.

Its is validating fine until the third statement which is

=Replace(ReportFilter([Code] Where ([Residual Likelihood]="High" And [Residual Aggregate Impact]="High"))

;(ReportFilter([Code] Where ([Residual Likelihood]="High" And [Residual Aggregate Impact]="Low")))

;(ReportFilter([Code] Where ([Residual Likelihood]="High" And [Residual Aggregate Impact]="Moderate"))))

but I am receiving the error (Missing operator or closing parenthesis in 'Replace' at position 309. (WIS 10067)) as soon as I input the 4th condition. I verified all the parenthese opening an dclosing but still has the issue. can you some one please help me here.

Below is the formula which is erroring out

=Replace(ReportFilter([Code] Where ([Residual Likelihood]="High" And [Residual Aggregate Impact]="High"))

;(ReportFilter([Code] Where ([Residual Likelihood]="High" And [Residual Aggregate Impact]="Low")))

;(ReportFilter([Code] Where ([Residual Likelihood]="High" And [Residual Aggregate Impact]="Moderate")))

;(ReportFilter([Code] Where ([Residual Likelihood]="High" And [Residual Aggregate Impact]="Substantial"))))