C/F Becoming B/F

[nevilledhamsiri]

I always need the calculated closing balance to be appeared as opening balances in the next Month. As per my calculation, figures are ok but it is appearing after C/F balance but I need to make it appear in the below row as b/f in February. Can some one help me to achieve this?

Thanks

Neville

[nevilledhamsiri]

Dear Members,Look forward for help

Thanks

Neville

[sunny_talwar]

Is this what you are looking to get to?

Try this

Aggr(
  Above(
    Sum([B/F]) + Sum(CONTRIBUTION) - Sum(SETTLEMENT)
  )
, BR_CODE, DES, DATE)

[nevilledhamsiri]

Actually, what is ended as C/F in January (10000,2500,12500) needs to be brought forward in February. In other words  in February it should be shown as below

BR_CODE	DATE	DES	B/F	CONTRIBUTION	SETTLEMENT	C/F
RA	1/1/2019	SAL_ADVANE	5000	2500	5000	2500
RA	1/1/2019	TRAVELLING	10000	5000	2500	12500
RA	1/1/2019	ADVANCE	2500	10000	2500	10000
RA	2/1/2019	SAL_ADVANE	2500	5000	1000	6500
RA	2/1/2019	TRAVELLING	12500	5000	1000	16500
RA	2/1/2019	ADVANCE	10000	5000	1000	14000

[sunny_talwar]

This seems to work for 2 dates, but might have to be tuned for multiple dates...

[nevilledhamsiri]

Thanks sunny for reply. Could you please forward me the expression used to fix the data as in the table you forwarded. I cannot open up your qvd. The formula you sent earlier, didn't help me to arrange the b/f  as I need.Please send me the expression used.

Thanks

Neville

[sunny_talwar · Accepted solution]

Expression for BF

Sum(Aggr(If(RowNo() = 1, Sum([B/F]), Above(SUM([B/F])+SUM(CONTRIBUTION)-SUM(SETTLEMENT))), BR_CODE, DES, DATE))

Expression for CF

Sum(Aggr(If(RowNo() = 1, Sum([B/F]), Above(SUM([B/F])+SUM(CONTRIBUTION)-SUM(SETTLEMENT))), BR_CODE, DES, DATE))+SUM(CONTRIBUTION)-SUM(SETTLEMENT)

[nevilledhamsiri]

Dear Sunny,

Thanks for the expression. Why the c/f  is not coming to appear in the B/F in February. Could you please see why the closing balance in January (c/f) is no coming to appear in opening balance(b/f) in February.

Thanks

[sunny_talwar]

Because you have not updated the expression for BF yet 🙂

[nevilledhamsiri]

Tanks Sunny

Neville