Problem with divide formula

English Forum
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…

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

3

What if I genuinely have a zero denominator.
Is there a function to show a ‘-’ (dash) instead of the word ‘ERROR’?

UPDATE: I just used the Cond formula

Thanks

2 Likes