Can you check addressing/partitioning (compute using) settings? You can access them from the pill context menu -> Edit Table Calculation. Window_AVG requires you to define the correct window to get the correct results. e.g. if your avg calc is at City level but you want to Average it one more time to State level then you would need to set your partitioning to State from Advanced... menu in compute using setting.