? showing up in calculation field
I have a Balance Due calculation field;
If ( OrderTotal - OrderPayments::PaymentTotal > 0 ; OrderTotal - OrderPayments::PaymentTotal ; 0 )
PaymentTotal is a summary field. I have the "Do not evaluate if all referenced fields are empty", unchecked. The "Do not store calculation results" is checked.
However the field only shows a "?" unless the PaymentTotal field has a value.
The funny thing is I have another field - ChangeDue - with a similar formula;
If ( OrderTotal - OrderPayments::PaymentTotal < 0 ; ( OrderTotal - OrderPayments::PaymentTotal ) * ( -1 ) ; 0 )
This field works flawlessly. I have tried removing it to see if that makes a difference to the BalanceDue field, but it does not. I have tried putting the 0+ in front of the formula, that does not change anything. Please help!