Skip to main content
Question

Percentage based on checkbox

Forum|alt.badge.img+7
We have several offices and managers. Each office and manager are in charge of several trucks. I have a check box formula that basically says if truck check date is last month, true else false. I need to create a report that says, for each office/manager what percentage, for their area, of their trucks had a check done. Or checks=yes/number of trucks. The percent of column total doesn't work on the summary because I need the percentage based on trucks assigned to each office/manager, not the percentage of the column. Any ideas?
    This topic has been closed for replies.

    You should be able to make a formula numeric field set to display Percentage called with a formula of

    if(=true, 1,0)

    then use the average of that in the summary report.
    Forum|alt.badge.img+7
    That worked perfectly. Thank you.
    We can get away with that "trick" because a truck is a truck is a truck and they are all equally weighted.  So the Average of the 0% and the 100% records is mathematically correct. 
    Terms & ConditionsAccessibility statement