Would you like to get a percentage automatically when you fill in your form on Kizeo Forms? This is possible!
Let take the example of an electrician who, during an electrical inspection with a customer, needs to be able to evaluate the different points to be checked and to have automatically at the end of its input:
The 3 steps below will help you create your certificate of compliance report that looks like you!
First, you must add a Choice or List field in your table and configure it with a code list: for each item, add two zeros to the code of the previous item starting from 1.
For example, for our « Observation list »:
Once you set your choice or list field, you have to:
The calculation to be set for each of these 3 Calculation fields is:
((The sum of the list – (the previous elements x 1 (the number of zero depending on the level of the element: 100 for the second, 10,000 for the third …)) % 100 (add two zeros for each Of the levels of the element: 100 for the first, 10,000 for the second …)) / 1 (and add two zeros for each of the levels: 1 for the first, 100 for the second …).
Our first element, Compliance observation:
Our second element, the Non compliance observation:
Our third element, N/A observation:
NB: This calculation is valid if your table contains less than 100 rows. Otherwise, it will be necessary to add three zeros instead of two.
On the mobile:
These calculations allowed us to obtain the number of times we chose an item from our list. Now, we would like to get this result as a percentage.
For example, our Compliance Percentage Calculation field will be set like this: (“Compliance Feed” / “Number of Entries”) x 100
Tips: In order for your result to appear with the percentage symbol, you can add the “%” to your calculation formula by clicking on “Add some text”.
On the mobile :
Do not hesitate to comment on this article!
All your questions, comments and suggestions are most welcome!