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!

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

That worked like a charm. Thanks so much Inky Phil!!