How to Calculate Completion Percentage Using Multi-Select Boxes
I’m trying to create a formula that calculates the completion percentage based on a series of multi-select checkboxes.
For example, if there are four checkboxes and three of them are selected, I’d like the formula to return 75%. Is there a way to achieve this in Quickbase? Any help would be greatly appreciated!
Thank you in advance!
Try this
var number NumberChoices = 4;
var text value = ToText([My Multi select field]);
var number NumberSelected =
Count(
Trim(Part($value,1,";"))<>"",
Trim(Part($value,2,";"))<>"",
Trim(Part($value,3,";"))<>"",
Trim(Part($value,4,";"))<>"",
Trim(Part($value,5,";"))<>"",
Trim(Part($value,6,";"))<>"",
Trim(Part($value,7,";"))<>"",
Trim(Part($value,8,";"))<>"",
Trim(Part($value,9,";"))<>"",
Trim(Part($value,10,";"))<>"",
Trim(Part($value,11,";"))<>"",
Trim(Part($value,12,";"))<>"",
Trim(Part($value,13,";"))<>"",
Trim(Part($value,14,";"))<>"",
Trim(Part($value,15,";"))<>"",
Trim(Part($value,16,";"))<>"",
Trim(Part($value,17,";"))<>"",
Trim(Part($value,18,";"))<>"",
Trim(Part($value,19,";"))<>"",
Trim(Part($value,20,";"))<>"");$NumberSelected / $NumberChoices
You should be able to use this formula by just adjusting the formula variables at the top so it knows the number of choices and also it knows which field to act on.