Forum Discussion

LeeGilmore1's avatar
LeeGilmore1
Qrew Member
8 years ago

Multiple Check Boxes Calculation to get % Complete

I have five check boxes that represent different phases of a construction project. Each check box is worth some of a total number of hours to complete the project. I want to create a field that calculates the % complete of the project based on which check boxes are checked. For example, if all five check boxes are worth 20% of the hours, if one is checked I want to indicate that we're 20% complete. If three are checked I want the field to show we're 60% complete. I know how to do this with five extra fields but assume there has to be a way to do the full calculation in one big formula field.
Formulas and functions

2 Replies

Sort By
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    8 years ago
    Here is a compact formula for a formula numeric field set to display in percent.

    count([cb 1], [cb 2], [cb 3], [cb 4], [cb 5])/5
  • LeeGilmore1's avatar
    LeeGilmore1
    Qrew Member
    8 years ago
    Thanks for the suggestion. I probably should have used a more complicated example to properly illustrate my end goal. A colleague explained the following example. It was over my head at first but both your suggestion and this example are much better than my initial, many field approach. Thanks again!

    var Number Phase1 = If([Phase 1],0.15,0);
    var Number Phase2 = If([Phase 2],0.55,0);
    var Number Phase3 = If([Phase 3],0.30,0);

    $Phase1+$Phase2+$Phase3