Num(Sum Error

[#1]

I'm hoping someone can help with this expression.  The first expression I have working with no issues:

='Actual - ' & num(sum([AE Expense Amount]), '$#,##0')

This one not so much.  I would like to get the sum of the expense field for the  current year inly without having to hard code it.  Any help is greatly appreciated.

='Actual - ' & num(sum({<Year={$(=$(vCurrYear))},[AE Expense Amount]), '$#,##0')

[ramoncova06 · Accepted solution]

you were missing the analysis closing bracket

='Actual - ' & num(sum({<Year={"$(=$(vCurrYear))"}>}[AE Expense Amount]), '$#,##0')

[#3]

Thank you greatly!!