R
Robin G
I have a pivot table which contains target values. I want to get an average
of the targets excluding the zeros. I've included simplified data below.
Fleet Subfleet location Target
PG PG1 42090 3
PG NC700 42090 3
PG SLAB 42090 0
average should calculate to 3 not to 2....
of the targets excluding the zeros. I've included simplified data below.
Fleet Subfleet location Target
PG PG1 42090 3
PG NC700 42090 3
PG SLAB 42090 0
average should calculate to 3 not to 2....