JTE scorecard - division by zero error in Open Discussion - Program Posted August 22, 2019 I was looking over the JTE scorecard as my troop was thinking about plans for the coming year. It puzzles me as to how to apply "retention" to a brand-new all-girl troop with a charter year ending in December. The percentage retention is to be calculated as Quote Number of youth members on the most recent charter renewal (A) divided by the number of youth registered at the end of the prior charter year (B) minus any age-outs (C). Total = (A) / (B-C). Age-outs are youth who are too old to reregister as Scouts. If the troop has a December charter, use the one expiring on December 31, 2018; otherwise use the one expiring during 2019. Percentage is thus (0-0)/0 If dividing by zero is bad, then dividing zero by zero is even worse! Does this mean that this is one less category available in which new troops can earn points? We already have enough points for bronze, but might not have enough categories (objectives).