How to calculate the cost automatically based on a fix value?

  • Profile Image
    Asked on November 20, 2017 at 05:00 AM

    I have a product where one cost is based on a specific value stated by customer. I therefore wonder, would it be possible to have customer type a value, and have the form automatically calculate the cost based on a fixed value in percentage? I'll give you some examples.

    Let's say that customer type 100 then I want the result/ cost to be calculated on 100 x 1.1% = 1.1. If customer types 2500, calculation should be 2500 x 1.1% = 27.5.

    If this is possible, I will replace the item "cost/ bonus". 


  • Profile Image
    Answered on November 20, 2017 at 09:53 AM

    Hello rbmans,

    Yes you can calculate fields and set the value using conditional logic.

    Here is a screen shot.

    To achieve this, in your build view go to settings then conditions

    Click the + add sign and choose UPDATE/CALCULATED FIELD

    In your IF "select the field where your customer inputs his value" in my case its Value then STATE to Is Filled.

    Do: Calculate a field's value then ADD FIELD, select the field in your IF then add your calculations. In you summery is where you want to put the output of your calculation.


    Here is the link to my form, feel free to clone it :

    Please let us know if we can be of further assistance.

    Best Regards.

  • Profile Image
    Answered on November 20, 2017 at 12:00 PM


    Took some time to realise that I can't use normal math and %. But using your formula it works.

    A bit curious of why it doesn't work though...


  • Profile Image
    Answered on November 20, 2017 at 01:26 PM

    You may also use a form calculation widget to perform calculations on the form without using any conditions. For the provided example, you may set up the formula as shown in the screenshot below:


    Please refer to the guide below that can help you with using the form calculation widget.

    Please get back to us if you need any further assistance. We will be happy to help. 

  • Profile Image
    Answered on November 20, 2017 at 01:32 PM

    Thanks, it does work with conditions as well. But only when using formula from above.

    Therefore I am A bit curious of why it doesn't work utilizing normal math or % though...

  • Profile Image
    Answered on November 20, 2017 at 02:45 PM

    I think what you're referring to is the normal percentage calculation.


    25% of 3000 = 750

    10% of 18 = 1.8

    I don't think there's a way to calculate the percentage mathematically without converting it to fraction or decimal first. When solving for percentage, 1.1% of X equates to X * 0.011. So you need to either use fractions as demonstrated on the examples given by my colleagues or go straight to using decimal by dividing the percent% value by 100.


    Use X * 0.011 instead of X * (1.1 / 100)

  • Profile Image
    Answered on November 20, 2017 at 03:06 PM

    Thanks for response but I was probably not clear enough. What I meant was that it is not possible to Use X * 0.011 

  • Profile Image
    Answered on November 20, 2017 at 04:31 PM

    I am not sure how you meant it was not possible... because using the Form Calculation widget as mentioned already should work for calculation like X * 0.011


    1511213325zzz 2017-11-21 05.26.44.png


    I hope this help. Let us know if you need further assistance.

  • Profile Image
    Answered on November 20, 2017 at 05:03 PM

    ok, actually it does not matter since it works with the formula sen before. Maybe I have to use the widget. I don't do that,. Only the condition settings.

    Any way thanks.

  • Profile Image
    Answered on November 20, 2017 at 07:46 PM

    Please note that the conditions wizard for calculations is similar to the calculation widget wizard so you can do the same too. 

    Here is a guide about it: 

    I hope this helps.