Ok, reran and checked------the total amount of claim spend is correct. The query is returning all claims regardless of date but only calculating the total on 2014. Is there a way to remove the results that are not applicable (2012-2013)?
... View more