Hi,
I'm looking for ideas on how best to approach my problem regarding condition scores of street lights.
Street lights are a point feature class and they have an overall condition rating (1 to 5). They also have 4 major components with overall component ratings (1 to 5). The 4 major components have individual pieces that also have individual ratings (1 to 5) that make up the overall component ratings. Having a few high score on individual pieces can skew the overall rating and lead to us missing one critical piece that may require attention.
Question 1 - Is it possible to auto populate the overall condition field by taking the average of other fields once they have been populated?
