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:
Views
Replies
Total Likes
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.DTOTelse
// display nothing
""
endif
Views
Replies
Total Likes
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!!
Views
Replies
Total Likes