Forum Discussion
zubairs
Helper I
5 years agoCalculate average from text column using month as base.
I have a report from HR that has the ID for each employee.
In order to get the total number of HC, I am taking the count of employee ID. This works fine when I'm applying filter for a one month.
The problem occurs when I'm selecting multiple months because the count measure adds both months. Whereas, I want it to get the average of the two months.
Any suggesstions?
1 Reply
- amitchandak
Super User