I have a view, one column averages the last 3 months sales. Sometimes the average is skewed by large values I would like to ignore.
e.g. if I have sales of 10 for month 1, 10 for month 2, and 100 for month 3, is there any way of ignoring the large number that is skewing the average? If so does anyone know the syntax?
Open in new window