Skip to main content
Question

SUBTRACT MULTIPLE FIELDS

  • Mar 20, 2018 10:00 PM UTC
  • 0 replies
  • 52 views
Hello I am trying to subtract multiple fields.  Here is what I am trying to do:

((payment amount) - (client fee) - (override) )/2

The main problem I am having is the override field has blanks so it does't recognize the formula.  Perhaps the field types need to be changed?

Payment amount - Currency Field
Client Fee - Currency Field
Override - Formula - Numeric

Thanks for your help.
      This topic has been closed for replies.

      • DanLadner1
      • Qrew Member
      • Mar 20, 2018 10:02 PM UTC
      Try this:
      Sum([Payment amount],-[Client Fee],-[Override])/2
      You have two choices.
      Set the properties of the [override] field to treat blank as zero.

      or else

      ([payment amount] - [client fee] - Nz([override]) )/2

      The Nz function will change a null numeric to a zero.
      • JakeJake
      • Author
      • Qrew Cadet
      • Mar 20, 2018 10:07 PM UTC
      Awesome... that worked!  Thank you!
      Terms & ConditionsAccessibility statement