Charts Give Wrong Distinct Counts

[progenysend]

I've got a report with 3 groups. Department, Invoice Number, and Age of Invoice.

Nothing is hidden or suppressed.

The Invoice Number (based on Age) can be In, Last, Out, or Aged.

I have a charts in the Report Header and Group Headers telling me a Distinct Count of Invoice Numbers in each category; In, Last, Out, Aged. Nothing fancy.

The Distinct Counts for In and Last are fine. Distinct Counts for Out and Aged are wrong. In one chart, a hand count gives 7 and 3, it is displaying 15 for both.

Any ideas?

Thanks

 

[lbass]

Are you using conditional formulas to count these? Please show the content of these formulas.

Can you also confirm your groups and identify the fields/formulas you are grouping on? Your current description doesn't make sense to me, as it seems invoice numbers should be Grp#3, not Grp#2.

Where are you placing the charts?

-LB

 

[progenysend]

Invoice is Group 2 because because I'm using an Audit trail, so the Invoice number comes up many times. This makes the final counted age based on the earliest change to the Invoice.

There are no formulas for the groupings, except Age, and that's just Changed Date - Created Date.

I'm using the basic distinct count provided by the chart.

 

[lbass]

Where do the "in, out, last, aged" come from? Isn't that a formula? In the chart expert, please explain what you are using for the "on change of" field and what you are using for the summary. If there are ANY formulas, please show the contents.

-LB

 

[progenysend]

I got it figured out. It needed to be told to take the minimum of In, Out, Last, Aged at the group level to do the Distinct Count.

Minimum({sr.Age},sr.InvoiceNum)

Then the distinct counts needed to be done off that.