🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

replace an outlier value with average of previous record & next record

User: "anildas"
New Altair Community Member
Updated by Jocelyn
replace an outlier value with average of previous record & next record 
Utilization
---------
78
80 
2000 (outlier)
91
76
I want replace if the Utilization >99.99 with the average of previous record and next record of the outlier (ie average of 80+91)

Find more posts tagged with