Average Balances in FSG
Hi,
User requirement:
Column 1: He needs to see average balances of Last Year
Column 2: He needs to see average balances of 1st Quarter
Column3: He needs to see average balances of 2nd Quarter
COlumn4: Aveage balances of 3rd Quarter
Column4: He needs to see average balances of Current Month
How to Cater above requirement as while running report, i will have to give a date on which system would average the balances. Now if will give date somewhere in second quarter then all the average balances will be calculated till that date which is wrong as it should be calculated as per above requirement.