Creating reports and dashboards | Stimulsoft community forum

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

Hello,

You can use function Div().

Thank you.

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

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.

Hi Aleksey,

very cool. Work perfect!!!:biggrin:

Regards
H. Dederichs

Hello,

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

Thank you.

Hi Aleksey,

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

Regards
H. Dederichs

Hello,

Sorry no. But we are working on it.

Thank you.