percentage calculation in a metrics sheet

Arjuna Quezada

I have a Metrics sheet where I have a count of the number of shipments that are early, ahead, or behind shedule. The count formula that is giving me the number of shipments ahead or behind is as follows: =COUNTIF({FCA Shipment Metrics Tracker Range 1}, <0)

I need a way to calculate the percentage of total shipments that represents in the same row. so for example row 1 should be 20%. the number of shipments will increase over time so I cant just input 6 as my total number of shipments

Screenshot 2025-05-12 111923.png

.

MedaUser

Hi @Arjuna Quezada,

I would write the formula in the Percentage column as follows:

=[Shipment Count]@row/SUM([Shipment Count]1:[Shipment Count]3)

MedaUser

Hi @Arjuna Quezada,

I would write the formula in the Percentage column as follows:

=[Shipment Count]@row/SUM([Shipment Count]1:[Shipment Count]3)