Sorry, by Constant 1, I just meant the number 1.

In the calculation property A for example, your formula would be: (Property A x 1)

That way unknowns for Property A stay unknown, but you can still include those in calculations as 0.

So for @GiantVoices example above. You would make a new calculation property for each of the properties in the proposed formula. For example "2015 Q1 Payment Amount Calc," which would equal (2015 Q1 Payment Amount x 1).

For records with unknown 2015 Q1 Payment Amount, 2015 Q1 Payment Amount Calc = 0

For records with a number entered in 2015 Q1 Payment Amount, 2015 Q1Payment Amount = the same number.

does that help?