Printable View
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.
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})
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
Post the formula.
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.
Unfortunately you cannot Sum a formula that uses Sum.
Without knowing more about your report I would just be guessing at possible solutions.