mcfarlandparkway (4/30/2014)
Thank you for the reply tried your sql code the problem is that the amounts are varying in free column and dollars column?Before that in free column for particular system its shown as 414 after rewriting as per your code its showing the free column as 2898
Not sure why amounts are varying.
I know why. I didn't include fiscalYear in the JOIN between vForAllSystemsForOneMonth and vSystemSchool. If you add that to the JOIN it should work. So it looks like you have data fro 7 fiscal years.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question