How to calculate data from Spreadsheet widget

I need to calculate the variation percentage of a serie of numbers in the spreadsheet widget

Hi Arona,

Thanks for reaching out to Jotform Support. I'll need some time to look into this. I'll get back to you as soon as I can.

We appreciate your patience and understanding.

Hi Arona,

Can you tell us what calculation you want to perform? Will you give us an example of the columns which the percentage calculation will be coming from? I've checked your Demande de Crédit Personne Morale form, and it appears that you're getting an error message at the F1 column. Check out my screenshot below:

When I changed the calculation to F1 = (E1/B1) on my cloned form, the error message disappeared. Check out my screenshot below:

Here's the result:

But, if you'll be using decimal places to calculate the percentage, let me show you how to do this:

1. In Form Builder, click on the Wand icon of the Spreadsheet widget.
2. From the General tab, under the Default Values, enter the calculation F1=E1*B1.
3. Click on Update at the bottom of the page.

Here's the result:

If this is not what you're referring to, can you explain more about what you want to happen?

After we hear back from you, we'll be able to move forward with this.

 Hello,
 Actually figured out how to perform the calculation. Thanx...
...