Form 5500- Participant count info on Amer Funds PP Plan

Does anyone know how to get the 5500 participant count out of reports on Amer funds Plan Premier?   If so what is the report name?  My client has a census of 5000 rows+ which includes a couple hundred duplicate rows because employees start and stop at different divisions (McDonalds franchises.)   We can't reasonably combine wages, deferrals, hours and pick earliest DOH and latest DOT etc to get it to load correctly into Relius.  If we could, Relius would provide the participant count.  I phoned Amer Funds who really can't help.  I asked them what would they do if this were bundled and they had to do the 5500?  I know they have the data as the plan sponsor provide a full census file every pay period combined for all divisions. 

Just struggling with this.   I think I can get close by sorting data exports by who has a balance and is not terminated, etc.  Not sure I can get everything though.  Fortunately it is safe harbor match, no profit sharing.  I will probably ask the advisor to take it bundled for 2024 -thinking ahead about LTPT.

Unfortunately I can't help with Plan Premier, but I perhaps have a different suggestion?

A pivot table in excel, done by someone who has some data scrubbing experience, with some rules thrown in about which dates to use if there is more than one (min, max etc) might get a single coherent census, in a couple of hours. 

I'm also surprised Relius don't have conditional importing of data points as an option. Something like, import rehire date unless the date in system is older. 

Or the ability to import and combine for things like compensation, as opposed to overwrite. 

I have several plans with AFPP and don't get a participant count from them; I get it out of Relius. You will need someone who is proficient with Excel so you can get the right data into Relius. From there you will be able to get a census with the correct information.