I have a summary report created and thought i could do a calculated field that concatenates the employee number, month and year. then if they have more than one record in any given month or year, count them as 1. otherwise 0?
The formula below is not working though and is still counting all records. Can this be done or is there a better way?
If(Count(List("","","",[Employee Number],ToText([Month No]),ToText([Year No])))>1,1,0))
Be the first to post a reply!