Problem with calculated columns

HowieD · Post by **HowieD** » Fri Sep 17, 2010 8:35 am

Dear Users,

I have created a calculated column where the a fieldvalue is divided by on other fieldvalue. Sometimes it can be the the divisor is zero.
On the data band it is no problem as the field returns 0.
As I want to total the field in the group footer an error is thrown who says that there is a division by zero (0).
What can I do to avoid this division by zero and where should it be done.

Thanks in advance.
H. Dederichs

Post by **Alex K.** » Fri Sep 17, 2010 8:44 am

Hello,

You can use function Div().

Thank you.

HowieD · Post by **HowieD** » Fri Sep 17, 2010 8:56 am

Hi Aleksey,

could you be a bit more specific since I'm very new to Stimulsoft.
A deeper explatiation would be highly appreciated.

Regards
H. Dederichs

Post by **Alex K.** » Fri Sep 17, 2010 8:59 am

Hello,

In a calculated column use Div(DataField1,DataField2)
In this case, you have the result of dividing by 0 will not cause error.

Thank you.

HowieD · Post by **HowieD** » Fri Sep 17, 2010 9:03 am

Hi Aleksey,

very cool. Work perfect!!!:biggrin:

Regards
H. Dederichs

Post by **Alex K.** » Fri Sep 17, 2010 9:09 am

Hello,

We are always glad to help you!
Let us know if you need any additional help.

Thank you.

HowieD · Post by **HowieD** » Mon Sep 20, 2010 8:29 am

Hi Aleksey,

is there any documentation about this or other functions?
Would have help before.

Regards
H. Dederichs

Post by **Andrew** » Mon Sep 20, 2010 9:15 am

Hello,

Sorry no. But we are working on it.

Thank you.