Skip to Content
author's profile photo Former Member
Former Member

Unable to solve missing parenthesis mystery

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"))))

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Mar 05, 2015 at 06:49 PM

    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
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Mar 05, 2015 at 06:29 PM

    Hi Rishi,

    what about the thrid parameter of the main Replace ?

    Regards,

    Rogerio

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.