I am trying to use the RangeAvg function to create an alert and should look like something below which one of you guys has already helped me out with. You think it would be easy that I could just replace [Record Count] with
I think it would be a lot easier to troubleshoot if you posted a sample app with your calculation.
Just by looking at the formulas, I suspect that the problem is caused by using the function After(). This is a Chart function that cannot be used outside of charts (i.e. in an Alert). The term After() pertains to the following row in the chart. Outside of the chart, the function is meaningless.
That's just a wild guess by looking at your rather complex formulas. If you'd like anyone to do any further analysis, please post a sample.