"Division by zero is not allowed" error

Forum|Forum|20 years ago
May 2, 2006
1 reply
2750 views

Hi all, I am using the syntax below:
<cfset PercentageOfConversionTotalLG = (totalCases.RecordCount/staffMember.RecordCount)*100/>

basically two recordset totals divided to give me a figure, sometimes this figure turns out at 0, so obviouslly 0% and that is what it shows, but other times it shows this error: Division by zero is not allowed, and refers to the above line of code... is there a way around this error? does anyone know please?

Many thanks in advance

This topic has been closed for replies.

K

Kronin555

Participating Frequently

> is there a way around this error?

Yeah, don't divide by zero.

In any programming language, if the denominator of a division operation is zero, an error is thrown. This is proper math.

Wrap it in a <cfif..>

<cfif staffMember.RecordCount neq 0>
<cfset PercentageOfConversionTotalLG = (totalCases.RecordCount/staffMember.RecordCount)*100>
<cfelse>
<cfset PercentageOfConversionTotalLG = "N/A">
</cfif>

S

SimonbullenAuthor

Inspiring

Thanks for the reply, when I run it though it throws; "The value "N/A" cannot be converted to a number "...?

P

paross1

Participating Frequently

Then change N/A to 0 so that PercentageOfConversionTotalLG will be 0%, if that is the result that you would expect if staffMember.RecordCount is zero.

<cfif staffMember.RecordCount neq 0>
<cfset PercentageOfConversionTotalLG = (totalCases.RecordCount/staffMember.RecordCount)*100>
<cfelse>
<cfset PercentageOfConversionTotalLG = 0>
</cfif>

Phil

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded