AnsweredAssumed Answered

? showing up in calculation field

Question asked by AmyWalsh on Sep 5, 2013
Latest reply on Sep 16, 2013 by philmodjunk

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

Outcomes