Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
we need solution on below mentioned issue. Attached file for your reference.
Issue :
1. 1. User enters end date in input box
2. 2. Based on that end date written formula to arrive the correct closing balances.
3. And we want to show another table last six months closing balances as showed below but unable to arrive month wise for the same
MONTH_NAME
Category
B
E
R
T
S
Total
Jan 2014
2,241,252
230,890,138
93,599,127
2,777,919
41,431
329,549,867
Dec 2013
2,237,296
219,561,433
95,542,465
3,138,738
320,521,362
Nov 2013
2,276,603
214,331,505
87,356,592
2,744,862
306,750,994
Oct 2013
2,338,107
212,351,117
84,776,745
3,503,767
42,030
303,011,765
Sep 2013
2,264,170
209,458,750
84,666,242
3,031,464
299,462,656
Aug 2013
2,291,017
209,975,734
92,491,299
3,996,015
42029.6
308,796,094