Computing Variances using Sum function

[#1]

I'm attempting to create a column that displays the difference between two columns utilizing the sum function.  I am able to compute successfully as independent expressions, but when attempting to put them in a single expression I render no results.

The expression is written as follows:

(=Sum({$<[BS Date]={"$(=Date(Max([BS Date])))"}>}[Total Adjusted Fair Value]) -

(=Sum({$<[BS Date]={"$(=addyears(Date(Max([BS Date])),-1))"}>}[Total Adjusted Fair Value])

Am I missing something here? 

[#2]

The first line of the expression calculates the Total Adjusted Fair Value for the Date = 12/31/14.  The second line of the expression calculates the Total Adjusted Fair Value for the date one year prior, 12/31/13.

[marcus_malinow · Accepted solution]

Just a syntax error

Your expression needs to lose the first equal signs before the Sum, within the parentheses

=(Sum({$<[BS Date]={"$(=Date(Max([BS Date])))"}>}[Total Adjusted Fair Value]) -

(Sum({$<[BS Date]={"$(=addyears(Date(Max([BS Date])),-1))"}>}[Total Adjusted Fair Value])

[#4]

Marcus,

Thanks, that worked.

[marcus_malinow]

Not a problem, happy to help.

Thanks for marking my answer correct