AnsweredAssumed Answered

Taking no action when a field is empty

Question asked by snkm on Jul 16, 2009
Latest reply on Jul 16, 2009 by RickWhitelaw

Title

Taking no action when a field is empty

Post

Here is my current formula:

 

If (IsEmpty ( Tester_Bug_Points );;

If(Tester_BugRatio=0 and PROJECTS:: Project_Bug_points_NEW >8 and PROJECTS:: Project_Bug_points_NEW <12;1;

If(Tester_BugRatio=0 and PROJECTS:: Project_Bug_points_NEW >3 and PROJECTS:: Project_Bug_points_NEW <9;2;

If(Tester_BugRatio=0 and PROJECTS:: Project_Bug_points_NEW <4;3;

If(Tester_BugRatio=0 or Tester_BugRatio>0 and Tester_BugRatio<.0249;1;

If(Tester_BugRatio>.025 and Tester_BugRatio<.0499;2;

If(Tester_BugRatio>.05 and Tester_BugRatio<.0749;3;

If(Tester_BugRatio>.075 and Tester_BugRatio<.09994;4;

If(Tester_BugRatio>.09995;5;"" ))))))))

 

If the Tester_Bug_Points field is empty, I want the score to not be calculated.  Any ideas?

Outcomes