Jump to content
  • 0

Account Running Balance


Mrudi

Question

10 answers to this question

Recommended Posts

  • 0

You can create a tabular report datapage. You can include a search box to filter by date or more if you want to. On the Results page of the datapage wizard, click on the field picker on the bottom and add in Totals & Aggregation. You can pick the field/column to use in the totals, which would be your transaction amount. Set this to Sum and you will have calculated total on the bottom of the report.

Link to comment
Share on other sites

  • 0
On 11/27/2019 at 9:13 AM, kpcollier said:

You can create a tabular report datapage. You can include a search box to filter by date or more if you want to. On the Results page of the datapage wizard, click on the field picker on the bottom and add in Totals & Aggregation. You can pick the field/column to use in the totals, which would be your transaction amount. Set this to Sum and you will have calculated total on the bottom of the report.

What if you want to show a sum accumulating total on each transaction line item

Link to comment
Share on other sites

  • 0
On 11/29/2019 at 9:59 AM, IvanCarlson said:

What if you want to show a sum accumulating total on each transaction line item

In the same tabular report, you can insert a Calculated Field column and use a formula to calculate the sum on each line item. These formulas are very versatile. If you are experienced with with JS, using an HTML block and using JS to do the calculations is a liiiiiiittle faster than using Calc Fields. Should only matter if you use a lot of them. 

Link to comment
Share on other sites

  • 0

Hi @Mrudi,

If you don't want to use Triggered Actions and you just want to display the running balance in the reports only, you can use a calculated field instead. 

You may use this formula:

(SELECT SUM(IsNull(Balance, 0)) FROM Running_Balance WHERE Date <= target.[@field:Date])

 

Balance is the name of the field where I store the amount and Running_Balance is the name of the Table. You may change these names based on your corresponding field names.

 

Hope this helps!

Link to comment
Share on other sites

  • 0

This example DOESN'T WORK! I followed it exactly and after working on it for a frustratingly three hours I could not get it to work. I kept getting an invalid formula. I tried it with a Tabular data page, I tried it with a Report and Chart datapage (which is where I need it). I recreated the table that the example used and still could not get it to work.

Has anyone made this work?

Lynda

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...