4 Replies Latest reply: Apr 21, 2015 11:51 AM by Marcus Malinow

# Computing Variances using Sum function

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]) -

Am I missing something here?

• ###### Re: Computing Variances using Sum function

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.

• ###### Re: Computing Variances using Sum function

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]) -

• ###### Re: Computing Variances using Sum function

Marcus,

Thanks, that worked.

• ###### Re: Computing Variances using Sum function

Not a problem, happy to help.

Thanks for marking my answer correct