I am trying to load Pay rate by max modification date, but it doesn't seem to be working correctly:
Maxstring(ModificationDate) as ModificationDate,
Max(PayRate) as PayRate
Group by AgentID;
I want one payrate per AgentID, here is the current output:
Let me know if you can help!