Report Showing Spurious Data for 0 SQFt Rooms
Hint Ref: 020706130001
Hint Date: 13/06/2007
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.