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

[FM] Count Distinct not working [SOLVED]

Started by dxwallace, 14 Aug 2007 01:03:50 PM

Previous topic - Next topic

dxwallace

I am setting the regular aggregate property of a calculation non-numeric account numbers to CountDistinct, but when I test that column I only get the original account number account number. Can someone tell me what I should do to get the distinct count of accounts. Is that number going to reside on each row, meaning will it count all the distinct account numbers and then put that number on each row? I'm a little lost In how this works?

SOLVED!!
This problem was solved by putting the count distinct WITHIN the calculation itself as oppoesed to having a calculation, and making the property of Regular Aggregate to be "count Distinct: