REPOST - "Arithmetic Over / Underflow" Error

Avatar

Avatar

RoC1909

Avatar

RoC1909

RoC1909

11-01-2011

THIS IS A REPOST INTO THE PROPER FORUM

Hey all,

I read all  the posts in regards to the "divide by zero" error that people get when  attempting division, but I cannot for the life of me figure it out.

I have a form where I "grand total" two columns, then with those totals, I want to perform simple "division" on it:

INTOT / DTOT

I  am getting the "Arithmetic Over / Underflow" error. (It's the  Administrative Rate field at the bottom of the form where I want the  "division" to be performed.)

I have tried numerous things  that I have read on these (and other) forums, but when I attempt  to  resolve this but then I start getting "Accessor" errors.

Can  one of the gurus take a peek at this and see what I might be doing  wrong? I know it's probably a very easy fix with one or two lines of  code, but this is getting frustrating.

Thanks,

Below is the file:

http://jump.fm/CLWSO

View Entire Topic

Avatar

Avatar

gkaiseril

Avatar

gkaiseril

gkaiseril

11-01-2011

You are not testing your divisor has a value and is not zero

// check for divisor having a value and not zero

if

(HasValue(Table1.FooterRow.DTOT) and Table1.FooterRow.DTOT <> 0) then

// perform division

Table1.FooterRow.INTOT

/ Table1.FooterRow.DTOT

else

// display nothing

""

endif