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

Cannot sum a counted member

Started by orbair, 18 Jun 2014 03:26:59 AM

Previous topic - Next topic

orbair

Hello everyone

I have a list, country, city..count(orders) and I would like to add a column % - count(order)/total(count(order)) but the result for every row is 100%. Can you please advise? Also the insert calculation button is inactive for count(order) column. Thank you for your help.

R.

MFGF

Quote from: orbair on 18 Jun 2014 03:26:59 AM
Hello everyone

I have a list, country, city..count(orders) and I would like to add a column % - count(order)/total(count(order)) but the result for every row is 100%. Can you please advise? Also the insert calculation button is inactive for count(order) column. Thank you for your help.

R.

How about count([Order item] for [Country],[City]) / count([Order item] for report)

Cheers!

MF.
Meep!

orbair