Divide-By-Zero

Izenda Logo

This documentation is for the legacy Izenda 6 product. Documentation for the new Izenda 7 product can be found at https://www.izenda.com/docs/

#Divide by Zero

##Question

I'm Getting #DIV/0 In My Report preview. What is this? Can I change it?

##Answer

If you accidentally divide by zero, Izenda would handle it by outputting the string "#DIV/0". However, you can change the output text with a custom format option. This functionality was implemented in release 6.7.0.258.

Usage; code for your Izenda global.asax:

// By default the display still shows "#DIV/0" when a divide by zero action occurs.


//To Display "Division by Zero Text"
(AdHocSettings.Formats.Get("DivisionByZero") as AdHoc.Formats.Formats.DivisionByZeroFormat).ReplaceText = "Division by Zero Text";


//To Display "0"
(AdHocSettings.Formats.Get("DivisionByZero") as AdHoc.Formats.Formats.DivisionByZeroFormat).ReplaceText = "0";


//To Display NULL (nothing)
(AdHocSettings.Formats.Get("DivisionByZero") as AdHoc.Formats.Formats.DivisionByZeroFormat).ReplaceText = "";