Export division by 0

[Charlessm]

I have a formula that helps with my division by 0 issue. Whenever I preview the report with data, everything comes out just fine. But when I try to export the report to excel, the division by 0 message pops up with the formula workshop. Is there something I'm missing? I am by no means an expert at crystal reports, any assistance would be appreciated.

 

[crystalkiwibruce]

Check your formulas.

If you have {field1} / {fieldb}

replace with
if {fieldb}=0 then 0 else
{field1} / {fieldb}

that should remvoe any divide by zero errors. I suspect the error is on a subsequence page. Preview only shows the first page while Export processes all pages.

 

[Charlessm]

Hi crystalkiwibruce. Thanks for your reply. As I mentioned below, I already have a formula. I've copied below.

whileprintingrecords;
if {@Gross Profit} <>0 then
{@Gross Profit}/Sum ({@Sales}, {LineItem.ItemID}) *-100
else 0

When I hit View > Print Preview, I can see all records and data. But when I try to export to excel, I'll get the division by 0 error message. I originally input the formula when I got the message when trying to Print Preview. I'll need another way to fix this. Thanks.

 

[kray4660]

Checking that {@Gross Profit} is non zero will not avoid the divide by zero error. You should check to see if Sum ({@Sales}, {LineItem.ItemID}) is zero.

whileprintingrecords;
if Sum ({@Sales}, {LineItem.ItemID} <>0 then
{@Gross Profit}/Sum ({@Sales}, {LineItem.ItemID}) *-100
else 0

 

[Charlessm]

Kray4660,

Worked perfectly! I'm still pretty new to this, a great learning experience. Thanks.