Forum Discussion

lotus22's avatar
lotus22
Helper III
5 years ago
Solved

Measure not working as intented

I have the following calculation and the table. For some reason, LO is not showing on for FTT% by Weld. I know why because the Fail calculation is zero. I do not how to show it on the graph as red be...
Need Help
  • nilimarodrigues's avatar
    nilimarodrigues
    5 years ago

    Hello,

     

    What if you update your FTT% By Welds formula to below:

     

    FTT% By Welds = if(Divide([Pass],([Pass]+[Fail]))=0,0.00001,Divide([Pass],([Pass]+[Fail])))
     
    Basically, you are giving a dummy value 0.00001 in case the division is going to result in value 0. That way, LO can be plotted on the chart:
     

     

    Kindly give Kudos if my reply helps!

     

    Thanks

nilimarodrigues's avatar
nilimarodrigues
Helper III
5 years ago

Hello,

 

What if you update your FTT% By Welds formula to below:

 

FTT% By Welds = if(Divide([Pass],([Pass]+[Fail]))=0,0.00001,Divide([Pass],([Pass]+[Fail])))
 
Basically, you are giving a dummy value 0.00001 in case the division is going to result in value 0. That way, LO can be plotted on the chart:
 

 

Kindly give Kudos if my reply helps!

 

Thanks