Expand my Community achievements bar.

Learn about Edge Delivery Services in upcoming GEM session

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!!