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?