Expression for cumulative figures

Upali_Wijearatne — Fri, 03 Jan 2025 17:01:31 GMT

I have below Pivot table in my qv file But I am unable obtain balance figure correctly. pls help me with the expression

Re: Expression for cumulative figures

Vegar — Sat, 04 Jan 2025 07:38:02 GMT

Do you need the if statement for handling the opening balance? If sorted correctly the balance will be the first row and therefore the same as the opening balance anyway.

Try also using replacing rowno() with rowno(TOTAL) in your expression.

Re: Expression for cumulative figures

Upali_Wijearatne — Sat, 04 Jan 2025 09:18:26 GMT

Thanks But it is not working properly.

1010	Bank Account - A/C 000405937 BOC Thimbirigasyaya	11-Dec-24	Re Investment of DESC FD	Direct debit	0.00	750,000.00	16,378,669.80
1010	Bank Account - A/C 000405937 BOC Thimbirigasyaya	16-Dec-24	Randika Dissanayake Monthly Contribution	1336	1,000.00	0.00	16,379,669.80
1010	Bank Account - A/C 000405937 BOC Thimbirigasyaya	31-Dec-24	Closing Balance	-	0.00	0.00	16,962,029.60
1011	Bank Account - A/C 1991497 BOC Milagiriya	01-Jan-24	Opening Balance	-	0.00	0.00	58,545.61
1011	Bank Account - A/C 1991497 BOC Milagiriya	05-Jan-24	Namal Silva	1034	1,000.00	0.00	17,021,575.21
1011	Bank Account - A/C 1991497 BOC Milagiriya	19-Jan-24	Mat of T Bills	1036	2,794.70	0.00	17,024,369.91
1011	Bank Account - A/C 1991497 BOC Milagiriya	26-Jan-24	Manjula	1035	250.00	0.00	17,024,619.91
1011	Bank Account - A/C 1991497 BOC Milagiriya	05-Feb-24	Namal Silva- monthly cont	1043	1,000.00	0.00	17,025,619.91
1011	Bank Account - A/C 1991497 BOC Milagiriya	07-Feb-24	Balance confirmation chgs	-	0.00	1,000.00	17,026,619.91

topic Re: Expression for cumulative figures in App Development

Expression for cumulative figures

Re: Expression for cumulative figures

Re: Expression for cumulative figures