Hi.
Using CR9.0, reporting from MSSQL database.
I've made a report consisting of quite a few formulas which calculates percent.
i.e
numerator / denominator
Sometimes the denominator is 0. I'm aware that I can do
If denominator <> 0 then
numerator / denominator
,but I don't want to go into each formula to do that (Lazy, I know, but there are hundreds of formulas...).
Is there somehow a global setting of some sort that can ignore this error and just output zero, instead of failing the entire report?
Thanks,
Bjorn
Using CR9.0, reporting from MSSQL database.
I've made a report consisting of quite a few formulas which calculates percent.
i.e
numerator / denominator
Sometimes the denominator is 0. I'm aware that I can do
If denominator <> 0 then
numerator / denominator
,but I don't want to go into each formula to do that (Lazy, I know, but there are hundreds of formulas...).
Is there somehow a global setting of some sort that can ignore this error and just output zero, instead of failing the entire report?
Thanks,
Bjorn