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 calcul...
Formulas and functions
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