I am trying to count the months between a user provided start and end date.
Within the report I have a ‘Calendar Month’ object and I have tried this calculation:
=Count([[Calendar Month];IncludeEmpty)
However this is only counting months that have data. I need to be able to count all months to then divide a total figure and establish a monthly average.
As you can see from below, I want all rows to state there are 7 months