IF statement -Syntax error

[Anonymous]

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?

[Anonymous · Accepted solution]

Hello all,

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

[PradipMCT]

Hi @Anonymous 

The comma is missing before "-". 

Regards,

Pradip Microsoft Certified Trainer

Pradip's YouTube Channel

[Anonymous]

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]

@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]

Hello @PradipMCT

Thank you!

I have send you the link in PM

[Mariusz]

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.