[RESOLVED] Summing

[artstar]

Hello:

Is there anyway to SUM a formula? I used a formula that calulates money value for each record. The reason I had to use a formula is because depending on different parameters in the record, each record is devide by a different number. So I had to create a formula. Now I need to total each of (@Dollar) formula for each group in my report.

[brucevde]

Assuming Crystal, if the Formula appears on the report you should be able to right-click and select the Insert -> Summary from the popup menu.

Otherwise, use Insert -> Summary from the main menu.

You could also write a formula
Sum({@Dollar}, {Same Field used in a Group})

[artstar]

Thats just it, If I try to use the insert method the formula field is NOT displayed. If I try to write another formula it tells me formula field CANNOT be summerized. Any other Ideas. This is CRYSTAL REPORT 9

[brucevde]

Post the formula.

[artstar]

Sum ({Credits.CreditIN}, {Machines.MchName})/{Machines.PulseDollar}

This gives me the correct group total per (Machine-group). Each machine is a group.But I also need a Total for each location group. 12 machines per location.

I hope this makes sense.
My formula is {@Dollar}
Thank You.

[brucevde]

Unfortunately you cannot Sum a formula that uses Sum.

Without knowing more about your report I would just be guessing at possible solutions.