Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: inu on 25 Nov 2017 12:11:11 PM

Title: How to calculate avg in dmr reporting
Post by: inu on 25 Nov 2017 12:11:11 PM
Hi Team,

I have to calculate
1. count(ID),
2. no. of days of selected date
3. Vertical (level)
4. Avg (count(ID) / no. of days of selected date)

So i am able to display all items 1, 2,3 but Avg not able to be displayed.
Can you please put some light on this. How to acheive AVG.


Regards,
Inam
Title: Re: How to calculate avg in dmr reporting
Post by: MFGF on 27 Nov 2017 03:31:19 AM
Quote from: inu on 25 Nov 2017 12:11:11 PM
Hi Team,

I have to calculate
1. count(ID),
2. no. of days of selected date
3. Vertical (level)
4. Avg (count(ID) / no. of days of selected date)

So i am able to display all items 1, 2,3 but Avg not able to be displayed.
Can you please put some light on this. How to acheive AVG.


Regards,
Inam

Hi,

You're going to need to give us a clue about how you're trying to do this. What does "not able to be displayed" mean? What have you tried? What results do you get?

MF.
Text only | Text with Images