12,633,079 members (33,028 online)
Rate this:
See more:
Hi All,

I am creating one crystal report.
In that report i have used formula fileds.when i place that formula field in report it shows Division by Zero error.

But formula filed having the value.I don't know why it is showing that error.

Sucharitha
Posted 31-Dec-12 1:48am
ChrisTopherus 31-Dec-12 6:52am

Can you be a bit more precise? Maybe with a little source... The only thing i can say at the moment is: it's not allowed to divide anything by zero.

Rate this:

## Solution 2

Add a simple check for zero to it.
{fielda} / {fieldb}

Check it first:
If {fieldb} = 0 then 0 else {fielda} / {fieldb}

Good luck!
Rate this:

## Solution 3

you can do this also...
{fielda} / iif({fieldb}=0,1,0)

Happy Coding!
:)
Rate this:

## Solution 1

yes friend you have to check your formula code ...

Top Experts
Last 24hrsThis month
 OriginalGriff 290 Peter Leow 175 CHill60 125 Jochen Arndt 80 F-ES Sitecore 72
 OriginalGriff 2,124 ppolymorphe 1,252 Peter Leow 979 John Simmons / outlaw programmer 695 CPallini 621