Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

IF statement -Syntax error

Hello all,

 

I have the following statement (see image)

However I get a Syntax error. I cannot see what I am doing wrong, since the same formula worked for me on another dataset.

It seems >0 is not recognized.

 

Can someone please help me out?

Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hello all,

     

    I am closing this thread since I found a work arround to solve issues, thanks for all the help.

     

6 Replies

  • Mariusz's avatar
    Mariusz
    Icon for Community Champion rankCommunity Champion
    7 years ago

    HI Anonymous 

     

    It looks like you are missing a "," behind "Yes") 

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    Mariusz Repczynski

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Thank your for your replies. PradipMCT and Mariusz 

      However I still get the same error

      This is what I have now:

       

      Vacancy check = CONCATENATEX(DISTINCT('emptyspaces-report'[Unit Ref]),IF(SUM('emptyspaces-report'[Condtional Column]) >0,"No","Yes"),"-")
       
       
       
       
       
      • PradipMCT's avatar
        PradipMCT
        Icon for Resolver II rankResolver II
        7 years ago

        Anonymous 

         

        Hope you're putting " (double quotes) and not ' (single quote twice).

         

        Can you share the data file?

         

        Regards,

        Pradip Microsoft Certified Trainer

        Pradip's YouTube Channel

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hello all,

     

    I am closing this thread since I found a work arround to solve issues, thanks for all the help.