calculate a percentage with a multiple choice formula
hello,
can I choose a multiple-choice answer in my formulas?
and how to calculate a percentage between 2 values with a multiple choice that contains 3?
13 replies
-
Hello,
You can use a formula like the following for this:
let myOui := cnt((select Table)[chosen('Multiple choice') like "Oui"]);
let myNon := cnt((select Table)[chosen('Multiple choice') like "Non"]);
"= " + format(myOui * 100 / (myOui + myNon), "0.00") + "% of Oui + Non"Best, Jörg
-
Hi,
Thank you for your answer. But i dont understand, sorry.
First, i need to insert a formula on the multiple choice on the « 1 »?
What do i need to write and where, for ninox to understand the 3 choices?
and after, i need write a formula on « 2 »?
-
Sorry, it's a choice, not a multiple choice.
-
You just need to insert the formula into a columns formula field (2 of your handwriting).
Please adjust the formula for the choice fields like follows:
For choice fields you can use that formula:
'choice field' = "oui"
You are also invited to learn the latest tipps and tricks or ask your questions in our webinar:
At our Ninox webinar tips and tricks will be presented in the first 30 minutes, the remaining 90 minutes will be used for a live support where the participants' concerns will be solved. You can register here for the webinar, which takes place every Tuesday at 18 o'clock CEST: https://zoom.us/webinar/register/WN_zoSk2qyNSz6vLRFF1zlakg
Kind regards, Jörg
-
I’m sorry but i dont understand. all student record have a field with 3 choices. « En cours », « Réussi » and « Loupé »
it’s En cours OR Réussi OR Loupé.
I would like to know the percentage of my students who have the checkmark "Succeeded" compared to the total of "Success + Missed"
I have insert this formula but the result is always 50%:
let myOui := cnt('1er essai' = "Réussi");
let myNon := cnt('1er essai' = "Loupé");
"= " + format(myOui * 100 / (myOui + myNon), "0.00") + "% of 1er essai" -
For example, i have 54 cards with « Réussi » and 11 cards with « Loupé ».
i would like the percentage of success.
-
Try this in your formula field:
let myOui := count((select YourTable)[text('1er essai') = "Réussi"]);let myNon := count((select YourTable)[text('1er essai') = "Loupé"]);"= " + format(myOui * 100 / (myOui + myNon), "0.00") + "% of 1er essai" -
Always 50%... :(
i can add two cases. total "Réussi", total "Loupé". and after i can add a formulas.
what formula should I put to have only the choice "Succeeded"
-
for all cards with "Réussi", not just one card ;)
-
It works for me...
Are you sure you are using a Choice field and not Multiple Choice?
-
that tells me that my table has not been found ... why?
-
slowwagon: "Are you sure you are using a Choice field and not Multiple Choice? " yes i can select just 1
-
It's OK!! i have rename the table with "ELEVES"
Thank you for your aid!!!
Content aside
- 5 yrs agoLast active
- 13Replies
- 6509Views