https://communities.sas.com/t5/SAS-Enterprise-Guide/Introduce-a-record-with-previous-values/m-p/6281#M1998 I am creating a report showing Account balances for every fiscal period. I need some suggestions ......if there is no activity in a month, the report should display the previous balance in missing period. <BR /> for example:<BR /> <BR /> Fiscal period account curr Balance prev balance<BR /> 00 1031 $-12,705,140.15 $-12,299,868.93<BR /> 03 1031 $-12,699,404.32 $ 0.00 <BR /> <BR /> I would like to add fiscal period 01 and 02 and show the balances as $-12705,140.15 $-12,299,868.93<BR /> <BR /> Please help. Thu, 10 Jan 2008 20:06:57 GMT deleted_user 2008-01-10T20:06:57Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Introduce-a-record-with-previous-values/m-p/6281#M1998 I am creating a report showing Account balances for every fiscal period. I need some suggestions ......if there is no activity in a month, the report should display the previous balance in missing period. <BR /> for example:<BR /> <BR /> Fiscal period account curr Balance prev balance<BR /> 00 1031 $-12,705,140.15 $-12,299,868.93<BR /> 03 1031 $-12,699,404.32 $ 0.00 <BR /> <BR /> I would like to add fiscal period 01 and 02 and show the balances as $-12705,140.15 $-12,299,868.93<BR /> <BR /> Please help. Thu, 10 Jan 2008 20:06:57 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Introduce-a-record-with-previous-values/m-p/6281#M1998 deleted_user 2008-01-10T20:06:57Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Introduce-a-record-with-previous-values/m-p/6282#M1999 I got help from SAS Tech support. I was able to resolve the issue. Fri, 11 Jan 2008 20:58:03 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Introduce-a-record-with-previous-values/m-p/6282#M1999 deleted_user 2008-01-11T20:58:03Z