> What is the C.Y. YTD & P.Y. YTD Interest?

What is the C.Y. YTD & P.Y. YTD Interest?

Posted at: 2014-12-05 
Current YTD:

sum( Case when CY = 1 and YTD = 1 then value else 0 end )

Previous YTD:

sum( Case when PY = 1 and YTD = 1 then value else 0 end )

CY/PY YTD Difference:

@Select(Previous YTD) - @Select(Current YTD)