My database has a parent table: Funds with child table: Balances. Funds has multiple entries, each of which has multiple-year entries in the Balances. I am try to sum the Beginning Balance column in Balances table by year. I get an end expected error with this select statement:

let ftot:= select Funds.Balances.'Beginning Balance-Temp' where Funds.Balances.'Year Ends April'='Fiscal Year'