Joined: 07 Nov 2018
Online Status: Offline
Posts: 8
Topic: running summary Posted: 10 Feb 2019 at 7:52pm
Hi I need to make an payment summary. And I have data as below :
Inv.Nu Date TOP Pay date Payment Balance
001 02-01-2019 1.000
01-01-2019 100 900
01-04-2019 50 850
02-15-2019 850 0
I need to calculate the balance following payment value. So the balance running by the row.
Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Posted: 11 Feb 2019 at 7:01am
You don't mention which version of Crystal you're using, but I'm going to assume that it's fairly current.
This is fairly easy to do. Crystal has a "Running Total" option that you would use. Basically, you would set it up like this:
Field to summarize: Payment field
Evaluate: For each record
Reset: On change of field Invoice Number field.
For my example, I will call this {#Payments}. The other assumption I'm going to make is that the first row that you're displaying comes from a "master" record that has the information about the total amount of the invoice. Then you would create a formula that looks something like this to display the running balance:
{Invoice Balance} - {#Payments}
Depending on how the data is set up, if the payments are already negative, you would use "+" in the formula instead of "-".
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum