Forum Discussion

afrutos's avatar
afrutos
Resolver I
4 years ago
Solved

If 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 In...
Need Help
  • AllisonKennedy's avatar
    AllisonKennedy
    4 years ago

    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.

AllisonKennedy's avatar
AllisonKennedy
Community Champion
4 years ago

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's avatar
    afrutos
    Resolver I
    4 years ago

    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

     

  • afrutos's avatar
    afrutos
    Resolver I
    4 years ago
    Medida = IF(( [ComprobacioD]>= 0 && [ComprobacioD]< 0.0000000000001 ) , "completada","incompleta")
     
    Now it's working !!
     
    thank you!