Pls help me in the syntax

[Green_Bricks_Ho]

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]

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.

help.appsheet.com

MAXROW()

Row with greatest value in column

help.appsheet.com

Dereference Expressions

Use a dereference expression to get a column value from the referenced row.