How to sum of ACCOUNTNUM starting with 2 will be the sum total prior to the month
To find the sum of ACCOUNTNUM starting with 2 will be the sum total prior to the month in transdate as if transdate = 2012-06, Opening of 21624000 shall be equal to -150,000, and if ACCOUNTNUM starting with 4 and 6 to be. totals prior to the month in that year but not more than that years. ex transdate = 2012-12, Opening of 49112000 shall be equal to -96.3 and transdate of 64120100 = 2013-09, Opening of 64120100 shall be equal to 2706027.4.
If you know script let me know or sent .qvw file please.