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

• rbmans
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".

• Richie_P
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 : https://form.jotform.com/73233569416965

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

Best Regards.

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

Thanks!

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

cheers

• Kiran
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.

https://www.jotform.com/help/259-How-to-Perform-Form-Calculation-Using-a-Widget

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

• rbmans
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...

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

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

e.g.

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.

e.g.

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

• rbmans
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

• jonathan
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

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

• rbmans
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.

• Kevin_G
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.

I hope this helps.