#DIV/0

Hi

Iam getting #div/0 error in my webi report

I attached File , you can see it .

How to solve this issue.

Thanks…
Div.PNG


Nike140984 (BOB member since 2015-06-12)

You can “error-trap” your calculation with the iserror function:

=if iserror([Your Calculation]) then [something else] else [Your Calculation]

HTH

NMG


mcnelson :uk: (BOB member since 2008-10-09)

are you using number/total or number/year. If anything you can avoid that error by applying the condition div/0=1 else 0


surya_sudheer :india: (BOB member since 2006-11-01)