Skip to Content
0
Former Member
Jan 18, 2013 at 04:22 PM

calculate 3months of data from the selected start fiscal yr

19 Views

Need to calculate 3months of data from the selected start fiscal year/period. Our fiscal year period is a string field and has values like 001/2011, 002/2011......

for eg: start fiscal year: 005/2011 to end fiscal year/period: 005/2012
the ouput should be as

005/2011-007/2011 008/2011-010/2011 011/2011-001/2012
---------------------- -------------------- -------------------
Sum(total rev) Sum(total rev) Sum(total rev)
soo on



Please reply to my query its very urgent...