[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1452
  • Last Modified:

Count total number of duplicates and non duplicates in a column

How would I provide a field in a report that would count the total number of duplicates and add another field to my report that would count the total number of non duplicates for instance

23333
23333
23333
11111

Total for duplicates - 3
Total for non-duplicates - 1
0
tupac1979
Asked:
tupac1979
  • 3
  • 2
2 Solutions
 
mlmccCommented:
Use a running total

Open the report
Click INSERT --> RUNNING TOTAL
Click NEW (may have to right click RUNNING TOTAL)
Name - countDupes
Field to summarize - YourField
Type of summary - count

Execute - Use a formula
{table.YourField} = Previous({table.YourField}) OR
{table.YourField} = Next({table.YourField})
Reset - Never

A similar total can be used for the other
Formula
{table.YourField} <> Previous({table.YourField}) AND
{table.YourField} <> Next({table.YourField})

mlmcc
0
 
tupac1979Author Commented:
When I use th 'reset- never' field an error message states that 'The remaining text does not appear to be part of the formula'
0
 
bbgbpCommented:
Reset - Never is not part of the formula. It's the last setting  on the Running total screen after you set your formula.
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
tupac1979Author Commented:
Thanks that helped but now I am getting the error message " This formula cannot be used because it must be evaluated later". Could you help me ?
0
 
mlmccCommented:
Add

WhilePrintingRecords;
 insert as the first line of the formula.

mlmcc
0
 
mlmccCommented:
Glad i could help

mlmcc
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now