COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: JPH on 30 Aug 2020 06:25:49 AM

Title: Unable to calculate average on a dataitem which is count of ids between 2 dates
Post by: JPH on 30 Aug 2020 06:25:49 AM
Hi experts,
I need to calculate average of a calculated data item which contains counts of columns for a date range.
e. g.  If x=count(id) for date1 and date2,  then i need
Average(x).
I tried of creating a separate data item but not showing any result.