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!

Divide by Sum Field

Status
Not open for further replies.

hermantb

Programmer
Aug 30, 2002
18
US
I have a SUM field for column A Total Order Qty, and column B is a formula field that totals up Only certain orders.
I am trying to then have column C that is B/A but it always shows 0%. Any idea why that happens?

Kind Regards,
Todd
 
The result of your formula is probably a fraction and is being rounded down to zero because you don't show decimal points.

Select the resulting formula (on the report layout) and click on the icon to add decimal places.

If that is indeed the case, just multiply by 100... :eek:)

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top