Clearly I'm using the wrong field to get average ticket paid amount. What field should i be using or what am I missing here? Any assistance is appreciated.
I've always had issues with the AVG function. I'll be interested in the solutions folks have.
Although, I suppose the most straight-forward solution would be to use [ (Ticket Paid Amount) / (Ticket Count) ], rather than any default AVG formulas.
Thanks - i guess the manual lifting is the way to go. Appreciated!