Adding numbers?

Tap Forms – Organizer Database App for Mac, iPhone, and iPad › Forums › Using Tap Forms › Adding numbers?

Viewing 1 reply thread
  • Author
    Posts
  • July 20, 2023 at 9:10 AM #49714

    Glen Forister
    Participant

    I have a problem adding number fields.  Why does a number field which is empty added to another number field with a number = Blank (an empty field)?

    If either of the fields is empty and not containing a number zero or another number, but just blank, why won’t the fields add up?  Do I have to add zeros to all my blank fields that are blank to get a number result?

    July 22, 2023 at 7:11 AM #49717

    Brendan
    Keymaster

    hi Glen,

    Yes, either you have to have a default value of 0 for all your Number fields, or your Calculation field formula must take into consideration empty fields.

    Use the IFEMPTY() function.

    For example:

    IFEMPTY(Number1Field; 0; Number1Field) + IFEMPTY(Number2Field; 0; Number2Field)

    That will check if the Number1/2Field is empty and if so, it will return a 0 in the expression. Then your formula will work.

    Thanks,

    Brendan

  • Author
    Posts
Viewing 1 reply thread

You must be logged in to reply to this topic.