I am working on a dashboard to evaluate transportation rates and provide the end user with an average cost based on selections made.
Selections are basically from and to and a few others.
What I want to do is evaluate the records based on selections and provide an average. That's easy enough. But I want to evaluate the records first and throw out any records with a cost that is outside the standard deviation. I'm trying to make the average as accurate as possible and want to avoid outliers increasing or decreasing the average artificially.
The data has a field called [Actual Cost] that I need to evaluate for the average. There are also records with 0 that I would want to exclude as well.
Seems I would need an IF statement in here. Just not sure on how the syntax would work.
These are the fields in the data load I'm working with.