Forum Discussion
Solved
AVG by Month
i have a column called Basis Month and another column called Has Basis. I have been trying to find a formula online where i can find the average basis per month. Every formula I have tried does not w...
Check the type on your Has Basis column. If it is text, then convert it to decimal in the query editor.
Pat
Group the table (or a copy of the table). Group by [Basis Month] and choose to Average [Has Basis].
Right click on the [Basis Month] column header and select "Group By" to get started.