Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can't create a summary/running total on the formula 1

Status
Not open for further replies.

TaylorTot

Technical User
Dec 23, 2003
96
US
I am trying to sum a formula.

My formula is // % of Contribution per AE
Sum ({@Sum of Pub Projections}, {Employees.Code})/Sum ({@Sum of Pub Projections}, {Publications.Code})

This will give me a percentage and I take that and multiply it by another number. From that I want to get the running sum, but this option is not available. Does anyone know a way around this?

I've been working on this for a while any help will be greatly appreciated!!
 
Due to Crystal's evaluation times, you can't do this. Manual running totals can be created by using three formulas. The first is an initializer formula for a global variable. The second increments (or decrements) the value of the variable. The third displays the value of the variable.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top