cmack Posted November 27, 2006 Share Posted November 27, 2006 I have a simple calculation of gains that student's have made on test scores. My problem is if the first score (field) blank it calculates as a - negative number. If the second score (field) is blank it gives me the number that is in the second field. So it looks like a gain even though there is no score to compare to. Test 1 score=100 Test 2 score=blank Gain/loss field shows [color:red]-100 Test 1 score=blank Test 2 score=100 Gain/loss field shows [color:green]100 I want it to show and empty field or a dash or something indicating that there is no comparison. Hopefully I have made some sense with what I need. Thanks in advance! Link to comment Share on other sites More sharing options...
Inky Phil Posted November 27, 2006 Share Posted November 27, 2006 OK Cmack you can set your calculation up with a case statement that will do what you want. Case(Isempty(test1)or isempty(test2);"";your calc). That should get what you want. You can replace the "" with a 0 if you would prefer HTH Phil Link to comment Share on other sites More sharing options...
cmack Posted November 27, 2006 Author Share Posted November 27, 2006 That worked like a charm. Thanks so much Inky Phil!! Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6360 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now