Can a calculation leave a field blank?

[researcher]

I'm setting up a calculation field with an If statement. If the result of the test is true, the result is 1. If the result is not true, the field must stay blank. How do I do that?

The field must be blank because I need to use it for a summary field, which will count all non-blank fields. If the calculation result is 0, the summary field still counts it as non-blank. I don't want the summary field to count false results of my calculation field.

Any suggestions? Thanks!

LR

[markpro]

Try something like this:

If(test,1,"") where "" means blank.

[researcher]

That did the trick!

Thanks very much!~

LR