Process Job Error when opening Report

[RDG55]

When trying to open a report from Destop Info I get the following error, anyone have any ideas.

ProcessJob(): Print job for viewing report(\\bhappsvr2\seagate info\output\~ci13rpn.rpt) fails with Error (PEEncapsulatePage : Error in formula <% Net Occupancy>. '(({@Occupied No Notice Null} + {@Vac Rented Null} + {@Notice Rented Null})/{@Unit Count Null}) * 100 ' Division by zero.)

 

[hilfy]

This is an issue with a formula within the report itself. At some point in your data, the {@Unit Count Null} formula is returning a 0 value. I would rewrite this formula:

if {@Unit Count Null} > 0 then
(({@Occupied No Notice Null} + {@Vac Rented Null}  + {@Notice Rented Null})/{@Unit Count Null}) * 100
else 0

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.