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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

formula - summary/running total error message.

Status
Not open for further replies.

luv2bike2nv

IS-IT--Management
Jun 28, 2007
90
US
I am really confused on this issue.
Crystal Reports 8.5

The report is Ontime delivery report.
The formulas i have that ARE working are as follows:

@On-Time
If {Detail.CurDue} >= {Detail.Shpdte}
Then {Detail.CurDue} - {Detail.Shpdte)

@Ontimecount
If {Detail.Curdue} >= {Detail.Shpdte}
then 1

@ontime%
Sum ({@ontimecount},{Detail.Cusdue}, "monthly" / Count {{Detail.Shpdte}, {Detail.CusDue}, "monthly"}

i need to change the @ontime% to be
Sum ({@ontimecount},{Detail.Curdue}, "monthly" / Count {{Detail.Shpdte}, {Detail.CurDue}, "monthly"}

the only difference is that instead of Detail.Cusdue it needs to be Detail.Curdue and when i check for errors I get the
"the summary/running total field could not be created"

I use Detail.CurDue in the other two formulas and I do not get error messages. CurDue and CusDue are just dates. (mm/dd/yyyy)

I do not understand why i would get that error message when i subsitute CusDue with CurDue.

Can anyone explain why this is happening and what i can do to get the @ontime% to work with Curdue?

If more information is needed I will gladly supply it.

thanks so much

RI
 
In the formulas, cusdue and curdue represent the group condition. If you don't have a group on curdue on change of month, you need to insert one.

I'm assuming those are not your actual formulas, since you have mistakenly used curly brackets instead of parens in certain places.

-LB
 
That was the problem---group on the wrong field so i changed it.
Thanks so much.
those are the actual formulas, i just typed them out instead of copy and paste them.
RI
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top