Knowledge Base

Report Showing Spurious Data for 0 SQFt Rooms

Hint Ref: 020706130001
Hint Date: 13/06/2007

Hint Details:

Problem: A report a User had written was showing spurious data for a sizecode with rooms of 0sq.ft. The line on the report picked up the details for another sizecode and displayed them instead of the correct one.


Solution: In the code there was a calculation to create £/sqft which should have returned a division by zero error by it didn't. The report ran and gave spurious info.

Sorting the division buy zero corrected the report.