Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Vergleich

Hi could someone please help me here;

Thanks in Advance

Need Help
  • AlB's avatar
    AlB
    3 years ago

    Hi Anonymous 

    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.

     

     

1 Reply

  • AlB's avatar
    AlB
    Community Champion
    3 years ago

    Hi Anonymous 

    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.