WebNov 19, 2014 · My report collects customer data by day which results in 130k-180k records for any 12 months. Some customers have as much activity two or three events per month. Is there a formula in Crystal Reports that can count the … WebJan 28, 2013 · Is there really no way to simply write a formula to go through each value of the day field, count the number of distinct loads in that field, if its over 5, create a tally, then spit out the number at the end, all self-contained in the formula? ... Brian's book has a very good explanation of how crystal uses data passes to build the report ...

Distinct Count Formula - Business Objects: Crystal Reports …

WebA basic function of crystal reports. A distinct count will return a single count telling me how many distinct values show up. For my example, it would return a single count equal to 90, since the values 1 through 90 are present. That's not what I want, as I indicated in the last few lines of my post. Thanks anyway. WebJan 21, 2011 · my second group is on DATE and did a distinct count on patientID and now I need to display only records for those where the distinct count is grater than 5. I have … crystal guild finder

Help - DistinctCount - i-net Clear Reports

WebJan 23, 2002 · Distinctcount is counting null values. I'm using CR7. The first formula gives me the serial numbers that match the criteria. The second formula is supposed to do a distinct count of those serial numbers. The result is it is counting the null values as a distinct "serial number". I've tried using if statements to exclude the nulls but this doesn ... WebOpen the Field Explorer (View > Field Explorer) Right-click on Running Total Fields and select New. Name: Enter a name for the Running Total. Field to summarize: … WebJul 26, 2024 · Create a formula {@date}: date({CARD_ACCESS_HIST.DATE_TIME}) Then create a second formula: distinctcount({@date}) This would count the number of distinct … crystal guinn