Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

RightParen error in Custom Column

Can someone help with this formula. I'm getting a RightParen error   if( [#"Which Centre do you work in?"] = "Box Hill" then "Australia"     I need to do multiple if then else statements whereby...
Need Help
sturlaws's avatar
sturlaws
Icon for Resident Rockstar rankResident Rockstar
6 years ago

hi Anonymous,

 

assuming your are trying to do this in Power Query, the syntax of the if-function is like this:

if test then value_if_true else value_if_false

without any paranthesis.

 

Cheers,
Sturla

If this post helps, then please consider Accepting it as the solution. Kudos are nice too.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    No this does not work with or wthout parenthesis

     

    Reminder I'm after text not a value

    if test then text_if _true else text _if_false

    • sturlaws's avatar
      sturlaws
      Icon for Resident Rockstar rankResident Rockstar
      6 years ago

      I can't make out what your column name is, but if you add a custom column in power query this is the syntax

      if [column name] = "Box Hill" then "Australia" else "Other"

       

      Notice that the comparison is case sensitive

       

      Cheers,
      Sturla

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        I domnt type in the column name I insert it from the list provided

         

        if( [#"Which Centre do you work in?"] = "Box Hill" then "Australia" else (from here a new if test begins)

         

         

        as soon as I start typing "Australia" the error appears