Distinct Count

[dev1212]

Hi,

I have a report. It is grouped by {org} and has details as {acct.acct_nb}. Below is more detail.

I want the distinct count of ORGUS as 2, i want to exclude 0 and include the distinct values of non zero account. Similarly i want the distinct count of ORGCAN as 4.

ORGUS
- 23412
- 45454
- 23412
- 0
- 45454
Distinct Count: ?
ORGCAN
- 13112
- 21454
- 13412
- 0
- 46454
Distinct Count: ?


How to accomplish this..?

 

[Charliy]

Use a Running Total that does a Distinct Count, use an Evaulate formula that says: {table.field} <> 0

 

[dev1212]

Can you please explain me in detail.
distinct count on what field..?
where to use the formula? -- in evaluate in running total?
reset where ?

 

[dev1212]

Any update please guys..?
How to accomplish the task..?

 

[pmax9999]

Hi dev122

Distict Count the field {acct.acct_nb}.

Place this formula in the 'Evaluate' part of "Create Running Total Field": {acct.acct_nb} <> 0

Reset "On Change of Group" and select the {org} group.


Cheers