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 >...
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.

     

PradipMCT's avatar
PradipMCT
Icon for Resolver II rankResolver II
7 years ago

Hi Anonymous 

 

The comma is missing before "-". 

 

Regards,

Pradip Microsoft Certified Trainer

Pradip's YouTube Channel

  • 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 PradipMCT

         

        Thank you!

        I have send you the link in PM