Is there a function that gives me the total number of days for a selected period
Is there a function that gives me the total number of days for a selected period?
On my report, the user is going to select a date range. I have a numerical chart, that should show the average value over the date range selected. However, i cant use the inbuilt average function because my dataset has multiple records for a single day (some with 0 or nulls). My average is not correct because of these records (and these records cannot be removed). Is there a way where i can take the sum and divide it by the number of days?