You should be able to do this by creating a calculated field similar to the following:
if sum([Actual])>=sum([Target]) then 'Target Met'
elseif sum([Actual])<sum([Target]) then 'Target Not Met' end
When this is placed on the view with the Milestone and Goals the correct output should appear. Hope this helps!
Thanks for the reply but I think you missed part of the problem that makes it tricky. I'm not interested in comparing RowX.Target to RowX.Actual, I want to compare RowX-1.Actual to RowX.Target. I want to compare the previous measuremnet in time Actuals to the NEXT measurement in time Target. Does this make sense?