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"))))
Hi Rishi,
To simplify the issue with parenthesis, why don't you try to use If then Else combined with Replace?
Thanks,
Mahboob Mohammed
Add a comment