4 Replies Latest reply on Sep 16, 2013 6:46 AM by philmodjunk

    ? showing up in calculation field

    AmyWalsh

      Title

      ? showing up in calculation field

      Post

           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!

           Thanks,
           Amy