Hi, I have a report which has fields ProjectNo, ProjectName, ProjectAmt and AmendmentAmt. Now the values would look something like this- ProjectNo ProjectName ProjectAmt AmendmentAmt abc-6008 ABC Reconciliation 1550,45.00 100.00 abc-6008 ABC Reconciliation 1550,45.00 4565.00 def-5482 DEF Reconciliation 48945,465.00 798.00 def-5482 DEF Reconciliation 48945,465.00 23.00 def-5482 DEF Reconciliation 48945,465.00 1032.00 So like you can see the the first 3 fields repeat for various AmendmentAmts. Now I want a count of the number of projects. In the above example it should be 2. When I do a count on ProjectName I get the value 5. Plese help me with this issue

hello, you can simply use the countdistinct aggregate function: =countdistinct(ProjectName)

Thanks....didn't know about this function

Thanks.... didn't know about this function.