Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

REPOST - "Arithmetic Over / Underflow" Error

Avatar

Level 2

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

2 Replies

Avatar

Level 7

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

Avatar

Level 2

Oh man!

I had something very similar to what you wrote.....except for my syntax!

Well, I am learning more and more all the time! This works perfectly, George!

Thanks again for all of your help!!