If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

How to calculate avg in dmr reporting

Started by inu, 25 Nov 2017 12:11:11 PM

Previous topic - Next topic

inu

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

MFGF

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.
Meep!