Forum Discussion

JakeJake's avatar
JakeJake
Qrew Trainee
7 years ago

SUBTRACT MULTIPLE FIELDS

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.

3 Replies

  • 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.