hmmm.
using your john smith example and showing details and placing the RateCalc formula on teh detail section you should have
john smith 8/1/13 $10.00 @ratecalc = (-10.00)
john smith 8/24/13 $12.00 @ratecalc = 12.00
the sum of the @ratecalc (at the employee gorup level) is 2.00
if you multiply that by the workdays you should get the difference amount you are looking for.
is this what you see? if not what do you see?
EDIT - i noticed i was missing some parenthesis in the original @ratecalc formula
Edited by DBlank - 06 Sep 2013 at 9:12am