+1 800 256 3608 (toll-free in North America) or +49 7531 90 60 10| service@combit.com

Problem with divide formula


(Kees) #1

Hello,

I’m having trouble with a formula. I want to divide field N303 with my xml field “ITEMCOUNT”. Here is the formula:

(Fstr$(val(N303)/n124 / val(ITEMCOUNT),"?&"))
Using this formula ERROR is shown beneath.

But when I’m using the multiple operator it works well:
(Fstr$(val(N303)/n124 * val(AANTALBANEN),"?&"))

So what’s going wrong here…


(combit Support - Christian Rauchfuß) #2

Hello Kees,

thank you for your post.

The problem could probably be a divison by zero in that case. Please make sure that val(ITEMCOUNT) is not NULL.

Best regards,

Christian Rauchfuß
Technical Support
combit GmbH