Error formulates "DAX comparison operations do not support comparison values of type TEXT"

[Syndicate_Admin]

Hello Community,

I have a problem with a formula, please your support

Classification =

IF(and(RECCS_Terreno[NotaFinal]=0,RECCS_Terreno[NotaTerreno]=0),"No presence",

IF(AND(RECCS_Terreno[NotaFinal]=0,RECCS_Terreno[NotaTerreno]<>0),"Incomplete",

IF(RECCS_Terreno[Contractor Category]="A"&&RECCS_Terreno[NotaFinal]>=90,"Acceptable",

IF(RECCS_Terreno[Contractor Category]="A"&&RECCS_Terreno[NotaFinal]>=80,"Moderate",

IF(RECCS_Terreno[Contractor Category]="B"&&RECCS_Terreno[NotaFinal]>=90,"Acceptable",

IF(RECCS_Terreno[Contractor Category]="B"&&RECCS_Terreno[NotaFinal]>=70,"Moderate",

IF(RECCS_Terreno[Contractor Category]="C"&&RECCS_Terreno[NotaFinal]>=80,"Acceptable",

IF(RECCS_Terreno[Contractor Category]="C"&&RECCS_Terreno[NotaFinal]>=60,"Moderate",

IF(RECCS_Terreno[Contractor Category]="D"&&RECCS_Terreno[NotaFinal]>=90,"Acceptable",'Unacceptable')))))))))}

Thank you!

[CharbelArmaleh]

Hello,

You need to check the data type of the following column

RECCS_Terreno[NotaFinal]

RECCS_Terreno[NotaTerreno]

RECCS_Terreno[NotaFinal]

they should be a whole number of decimal

Did I answer your question? Mark my post as a solution!