There is probably a better way to do this but I need to capture all of these conditions, for example, if scope was .12 and costVariance was 0 and
ScheduleVariance .011 I would divide by 2 to get the average, or just use the Avg function for the two with values <>0. Or if all 3 had values >0 I would just add them and divide by three
and so on.
I am gettig the right results in the query i have pasted at the bottom of this post
View Complete Post