Is there a way to round the amount by the nearest $100.00?

  • STEVESACE
    Asked on August 8, 2019 at 12:59 PM

    We are providing quotes for high dollar amount items. We would like to round the "Estimated price" to the nearest $100. I found how I can round to the nearest dollar but this won't work for us. 

  • Vanessa_T
    Replied on August 8, 2019 at 1:52 PM

    I see you're using conditions to calculate the value of the Estimated Price. For easier setup, may I suggest to use Form Calculation widget.

    How-to-Perform-Form-Calculation-Using-a-Widget

    In the widget's settings, you can use the following formula to round to the nearest 100.

    1565286622Screen Shot 2019 08 09 at 1 Screenshot 10

    1565286722A Screenshot 21

  • STEVESACE
    Replied on August 8, 2019 at 2:59 PM

    So I've added another field to have the calculation widget. It doesn't seem to be working correctly. Can you look at my form again. 

    ex. 

    Manufactured price $799.00

    Add a certain percentage based on manufactured price to get the calculated price

    Then round to nearest 100

  • STEVESACE
    Replied on August 14, 2019 at 10:25 AM

    I still need assistance with this question...

  • Vanessa_T
    Replied on August 14, 2019 at 8:49 PM

    Apologies for the delay, it seems that your last posts were missed.

    I can see that on your Calculation field, you added conditions to calculate it's value. You actually got the process right but I'm not sure if the values you have entered are correct.

    1565829559Screen Shot 2019 08 15 at 8 Screenshot 10

    In the conditions above, there'll be some values that will not have calculations. Sample, if Manufacturer's price is exactly 200, it does not fall to any conditions. It is not below 200 (condition 1 fails) and it is not greater than 201 (condition 2 fails).

    Are you instead planning on having these calculations:

    Manufacturer's price is 0-200, then add 40%

    Manufacturer's price is 201-800, then add 35%

    Manufacturer's price is greater than 800, then add 30%

    If yes, then please change your conditions to below:

    1565829594Screen Shot 2019 08 15 at 8 Screenshot 21

    Also, on your Form Calculation widget, make sure that numbers as well as mathematical functions are having the Number format and not the String like below.

    Is there a way to round the amount by the nearest $100.00? Image 32

    To change the format, simply click on the text.

    Is there a way to round the amount by the nearest $100.00? Image 43

  • STEVESACE
    Replied on August 16, 2019 at 11:39 AM

    I have made those changes but it still isn't calculating. This is what I am getting in the Estimated retail price field on the PDF. 

    1565969940Jotform Screenshot 10

  • John_Benson
    Replied on August 16, 2019 at 1:05 PM

    It is possible that the round function in the calculation widget is still in String mode which is why the field shows the formula instead of the result.

    1565974799round funct Screenshot 10

    Here's an example:

    1565974823testproof1 Screenshot 21

    I cloned your form and I can see that it is now in Number mode. I tested your form and entered the 799.00 value in the Manufacturer's price. After doing that, the Estimated retail price field shows the correct value. Here's a screen capture from your form:

    1565974982testproof2 Screenshot 32

    Here's the PDF result of the clone form:

    1565975069result Screenshot 43

    I believe that you already fixed the issue based on my test. I suggest you do a test submission again and let us know if you're still having problems.