Hi
I have a solvent ratio report that sees every month separetly
Nbr of delivered invoices each month
Amount paid on these etc….
Presented like this:
2013
Month - Nbr_Inv - Recevied_Pricipal - Current_Pricipal - Paid_Principal - SolventRatio
Janury - 428 - 500 - 200 - 300 - 60%
January - 500 - 600 - 350 - 250 - 41,6%
etc.....
The solvent% here is a calculation within each month.
The sums are all connected to the invoices delivered in each month.
Now there is also a wish to get a new figure in, a acumulated solvent ratio
Month 1 will be as is
Month 2 will be calculated of the sums of month 1 og 2 etc…
Ex:
Month 1: 428 invoices - Principal: 500 – Paid 300 – Solvent = 60% - accumulated = 60%
Month 1: 500 invoices – Principal: 600 - Paid 250 – Solvent = 41,6 - accumulated = 30%
Added as a New column:
Month - Nbr_Inv - Recevied_Pricipal - Current_Pricipal - Paid_Principal - SolventRatio - AccSolvent
Janury - 428 - 500 - 200 - 300 - 60% - 60%
January - 500 - 600 - 350 - 250 - 41,6% - 50%
The calculation in itself is not the issue. The problem is to get Crystal to do as I wish. I have tried several things.
I have tried making separate running totals and trying to make separate formulas to calculate each month.
A running total for month 1 yr 1 + Month 2 Yr 1 etc… and then using these numbers to make a solvent ratio for each month ahead, each formual adding a new month. But this does not work. Each running total becoms 0 when used in a formula not connected to its current mont/group
Anyone have an idea on how to make this work, and if there is a way of doing this without making a formula for each month but a function/formula that can work by itself and calculate a accumulated solvent ratio
hope I managed to provide a comprehensible explanation on what I am trying to acomplish
Best Regards
Ernst Noto
I have a solvent ratio report that sees every month separetly
Nbr of delivered invoices each month
Amount paid on these etc….
Presented like this:
2013
Month - Nbr_Inv - Recevied_Pricipal - Current_Pricipal - Paid_Principal - SolventRatio
Janury - 428 - 500 - 200 - 300 - 60%
January - 500 - 600 - 350 - 250 - 41,6%
etc.....
The solvent% here is a calculation within each month.
The sums are all connected to the invoices delivered in each month.
Now there is also a wish to get a new figure in, a acumulated solvent ratio
Month 1 will be as is
Month 2 will be calculated of the sums of month 1 og 2 etc…
Ex:
Month 1: 428 invoices - Principal: 500 – Paid 300 – Solvent = 60% - accumulated = 60%
Month 1: 500 invoices – Principal: 600 - Paid 250 – Solvent = 41,6 - accumulated = 30%
Added as a New column:
Month - Nbr_Inv - Recevied_Pricipal - Current_Pricipal - Paid_Principal - SolventRatio - AccSolvent
Janury - 428 - 500 - 200 - 300 - 60% - 60%
January - 500 - 600 - 350 - 250 - 41,6% - 50%
The calculation in itself is not the issue. The problem is to get Crystal to do as I wish. I have tried several things.
I have tried making separate running totals and trying to make separate formulas to calculate each month.
A running total for month 1 yr 1 + Month 2 Yr 1 etc… and then using these numbers to make a solvent ratio for each month ahead, each formual adding a new month. But this does not work. Each running total becoms 0 when used in a formula not connected to its current mont/group
Anyone have an idea on how to make this work, and if there is a way of doing this without making a formula for each month but a function/formula that can work by itself and calculate a accumulated solvent ratio
hope I managed to provide a comprehensible explanation on what I am trying to acomplish
Best Regards
Ernst Noto