CANT MAKE A DIVISION IN A SPREADSHEET DEFAULT VALUES!!

  • Profile Image
    Studio2025
    Asked on September 02, 2019 at 02:20 AM

    HI IVE PLACED A SPREADSHEET AND BEEN WORKING AROUND ON THE DEFAULT VALUES MATH OPERATION, BUT CAN PLACE A DIVISION ON IT 

    EX 

    A8 = A7 / A6 

    IT GIVES ME AN ERROR MESSAGE 

  • Profile Image
    aliemir
    Answered on September 02, 2019 at 06:18 AM

    Actually, this is not an error message. The default value is 0(zero) in the widget settings. That's why you get this error because an undefined result appears when you try to divide some results. To illustrate this, I cloned the form and you will see that there is no error when a defined division is performed in the preview of the form. You can see the screenshots below.

    First, I add a division to your form;

    1567415448Screen Shot 2019-09-02 at 12.0

    Then, when enter some inputs to your table, there will be no error as shown below.

    1567415746Screen Shot 2019-09-02 at 12.1

    If you have any further questions, please feel free to let us know.

  • Profile Image
    Studio2025
    Answered on September 03, 2019 at 12:13 AM

    woow thanks!!!