Using a running total in a formula

[bentley31]

I am using Crystal Reports XI. I have a report with 4 groups and displaying data in group footer 3 (business load period). I have a formula to show the total payments in each load period (group footer 3) and a running total to show the business loaded in that period. I want to create a formula to show the payments as a percentage of the business loaded. Is there anyway I can use the running total field in a new formula, so the formula would read:-

(total payments formula / business loaded runnning total) * 100??

 

[JDNordberg]

Bentley, I am assuming you are using summary fields to display both your running totals as well as your grouping totals. I do not think that you can use the summary formuals in another formula, but you can create a formula field that will accomplish what you are trying to accomplish.

ie.

Group three label = Q3
Value being summarized = Payments

the formula would read

sum({payments},{Q3})/sum({payments})*100

This would give you the percentage delivered by the third grouping against the grand total or "running total"

The sum({payments},{Q3}) tells Crystal that you want to sum a field based on a specific grouping.

I hope that helps.

JD

 

[lbass]

You should be able to use:

{@totalpayments} % {#runningtotal}

-LB

 

[bentley31]

Thanks for that - using the formula % running total worked exactly how I wanted it to.