d.paulson
January 15th, 2000, 10:18 PM
I am using Crystal Reports to report from an access db. For ex I have sales | Cost | Profit | and margin columns. Profit & margin are calculated fields.I have used Inventory.YTDSales > 0 in the record selection. @Margin is @Profit/Inventory.YTDSales . @Margin returns a Div by 0 error. I modify @margin formula to a value and form will populate.In the form preview i can edit the @margin field to original formula and it is displayed correctly. I can the refresh data and will come up with div by 0 error again.
Note: No records in Inventory.YTDSales had a value of 0.
Any Ideas?
Note: No records in Inventory.YTDSales had a value of 0.
Any Ideas?