1 Reply Latest reply on Sep 20, 2012 4:57 PM by Tracy Rodgers

    Variance to Prior Year End

    Sara Dixon

      Hi Everyone,

       

      I'm have trouble with my formula to calculate a variance to prior year end.

       

      I have three different formula:

      Auto 2011 YE = if [Termination Date] = DATE(12/2/2011) then [LEW %] end

      Auto Current Month = if [Termination Date] = DATE(7/1/2012) then [LEW %] end

      Auto Var to 2011 YE = [Auto Current Month]-[Auto 2011 YE]

       

      The first two I keep getting the error "cannot mix aggregate and non-aggregate comparisons or results  in "if" statement".

       

      Anyone have any idea how I can fix this?

       

      Thanks!

      Sara

       

      Note: In my data source I have all the data from YE 2011 in as the date 12/2/2011 and the date for July (the current month I'm working with) as 7/1/2012