If not working

[afrutos]

Hello everyone, 
I have this table, with my measures
and everything is working fine except the if function,
I would like to have: if my column "ComprobacioD" is 0 then is completed otherwise is Incomplete.

But it's not working.
Can anybody help me?
Thanks

[AllisonKennedy · Accepted solution]

@afrutos  What's the measure for comprobacioD? Is it possible that it's not exactly 0? Try changing your if to 

<0.00000001 and see if that helps, then continue troubleshooting from there.

[afrutos]

Medida = IF(( [ComprobacioD]>= 0 && [ComprobacioD]< 0.0000000000001 ) , "completada","incompleta")

Now it's working !!

thank you!

[afrutos]

the is the measure for ComprobacioD: 

ComprobacioD = [SUM DIR] - [SUM % Distribucion Obra D]

This is working a little bit better but then it should be between 0 and <0.00000001

I'm a little bit lost