Using the same data, the following code sequence produces different results in the design environment as compared to the runtime environment.

lparameters thisfield, fundscx, lnForecastYear, lnCurrentTIPYear
clear
set exact off
set Deleted On
sele tip
local lnThisrec
lnThisrec = recno()
***************** Step 1 get prior year expenses based on fisyear 
sele * from ledger ;
	where fisyear < lnCurrentTIPYear and source = fundscx and deleted()=.f.;
	order by fisyear ;
	into cursor carryover
sum -amount * factor to net_prior

Any ideas on what might be causing this would be appreciated.