Division by Zero 1

[TriciaDPD]

This report has many formulas calculating the %.
But this one is giving the 'Division by Zero error message.

The formula for "{@transfer in}" is
whileprintingrecords;
shared numbervar totparcels;

The Formula I'm having trouble with is:

(Sum ({@Damaged Refused}) + Sum ({@MD DPD error}) + Sum ({@Late}))
% ({@transfer in})

Help would be greatly appreciated!

 

[lbass]

if {@transfer in} <> 0 then
(Sum({@Damaged Refused})+Sum({@MD DPD error})+Sum({@Late}))%{@transfer in}

-LB

 

[TriciaDPD]

Thanks for your quick responce!

This is returning a value of 0?

 

[lbass]

You would get a zero if {@transfer in} = 0. Make sure you have clicked on the % icon and that the formula is formatted to allow enough digits to show in case it does have some value.

For this to work, the formula must be in a section below the one containing your subreport. If the sub is in RF_a, then the formula should be in RF_b.

-LB

 

[TriciaDPD]

Oh Brilliant!
They were both in the same field. I didn't realise.
Working now. Thank you so much'