Forum Discussion
Resolver IIf not working
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
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.
3 Replies
- AllisonKennedy
Community Champion
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.
afrutosthe 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
- afrutosMedida = IF(( [ComprobacioD]>= 0 && [ComprobacioD]< 0.0000000000001 ) , "completada","incompleta")Now it's working !!thank you!