Simple Formula Question - Newbe...

[eorderspro]

Hello everyone!

I'm glad to see there is a forum for Crystal Reports... I have a quick question. I have a summary already that is Sum of Orders... But now I want to take the Sum of Orders and divide that by a number. Does anyone know the formula for that?

It doesn't sound too hard but I'm lost. I can do all this easily in Access but all our reports are in CR.

Thanks for the help

 

[lbass]

Go to insert->formula field->new and enter:

sum({table.order})/{table.number} //substituting your fields

Or if you meant you want to divide by a constant:

sum({table.order})/n //where n = your number

If the sum is at the group level, the formula would look like:

sum({table.order}, {table.grpfield})/n

Then drag the formula to the report canvas.

-LB