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

  • Profile Image
    Asked on August 08, 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. 

  • Profile Image
    Answered on August 08, 2019 at 01: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.


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

    1565286622Screen Shot 2019-08-09 at 1.50


  • Profile Image
    Answered on August 08, 2019 at 02: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. 


    Manufactured price $799.00

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

    Then round to nearest 100

  • Profile Image
    Answered on August 14, 2019 at 10:25 AM

    I still need assistance with this question...

  • Profile Image
    Answered on August 14, 2019 at 08: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.38

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

    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.


    To change the format, simply click on the text.


  • Profile Image
    Answered 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. 


  • Profile Image
    Answered on August 16, 2019 at 01: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.


    Here's an example:


    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:


    Here's the PDF result of the clone form:


    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.