Spreadsheet Widget: Is it possible to round the calculated amount to 2 decimal places?

  • Profile Image
    HIPACFinance
    Asked on June 25, 2019 at 04:00 PM

    https://form.jotform.com/HIPACFinance/maui-daily-sales-report

    Attached is the link to my form.  The spreadsheet widget calculates my totals incorrectly and I do not know how to fix it.

    1561492809jotform error.PNG

  • Profile Image
    Kevin_G
    Answered on June 25, 2019 at 06:52 PM

    I have been performing some tests and I can see the widget calculates properly; however, it shows the full string without reducing the number of decimals, actually it's not possible to change this. 

    I will be opening a feature request for this, although we cannot provide an ETA, we will keep you updated via this thread.