zero divide error in my query sq01

[Former Member]

Hi Gurus

I keep getting a 0 divide error in my query, I think it's because some of the invoices have 0.00 dollars amount, t

For Contribution Margin in sq01 I wrote a formula in Calculation formula

CONT_MARG / (MAT_PRC-FRGT_PROV + DISC_SURC+FREIGHT ) * 100

Condition : MAT_PRC-FRGT_PROV <> 0 OR DISC_SURC+FREIGHT <> 0.

after running the invoice I am getting an error as zero divide in the report

Any help will be appreciated

Thanks in Advanced

[Former Member]

Hi Gurus

I keep getting a 0 divide error in my query, I think it's because some of the invoices have 0.00 dollars amount, t

For Contribution Margin in sq01 I wrote a formula in Calculation formula

CONT_MARG / (MAT_PRC-FRGT_PROV + DISC_SURC+FREIGHT ) * 100

Condition : MAT_PRC-FRGT_PROV <> 0 OR DISC_SURC+FREIGHT <> 0.

after running the invoice I am getting an error as zero divide in the report

Any help will be appreciated

Thanks in Advanced

[Former Member]

Hi,

Change your query like below

define a local variable l_variable.

l_variable = (MAT_PRC-FRGT_PROV + DISC_SURC+FREIGHT ) * 100 .

IF l_wariable IS NOT INITIAL.

CONT_MARG / l_variable.

ENDIF.

Regards,

Atish