Vergleich

[Gaucho]

Hi could someone please help me here;

Thanks in Advance

[AlB · Accepted solution]

Hi @Gaucho 

You are comparing [HilfsKonto] = 0  [HilfsKonto] = "" , ie, comparing to text and number. One of them is wrong; a column can only have one data type and comparisons only make sense between the same data type. 

What type is [HilfsKonto]?  You might have to change it.

If you don't, you'll either need [HilfsKonto] = "0"  or [HilfsKonto] = BLANK()

Please accept the solution when done and consider giving a thumbs up if posts are helpful.  Contact me privately for support with any larger-scale BI needs, tutoring, etc.