Pls help me in the syntax

[Green_Bricks_Housing (PRAVEEN)]

1. IF I CHOOSE A PARTICULAR [MATERIAL] eg… CEMENT I NEED THE CLOSING BALANCE FOR THAT PATICULAR MATERIAL.
2. PREVIOUS DAY CLOSING BALANCE SHOULD BE NEXT DAYS OPENING BALANCE FOR THAT PARTICULAR MATERIAL.
   PLS. HELP ME WITH THE SYNTAX .
   THANKS IN ADVANCE,

[LeventK (Levent Kulacoglu)]

Create a VC with MAXROW() expression to establish a reference with the last record and then simply use a de-reference in the initial value.

MAXROW()

Dereference Expressions