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

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

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

       

      Am I missing something here?