Skip to Content
0
Former Member
Jun 11, 2007 at 09:38 AM

Problem with "####" sign where percentage should be !!

9 Views

Hi everybody, i got query that draws a typical structure

Rooms 1 2 3 4 +4 TOTAL

ENE 2006 22 96 126 7 253

FEB 2006 33 99 106 7 245

MAR 2006 21 106 111 12 253

ABR 2006 27 86 65 9 188

MAY 2006 28 83 76 10 197

JUN 2006 23 70 57 4 157

JUL 2006 37 84 46 6 178

AGO 2006 20 64 61 2 147

SEP 2006 31 60 67 6 167

OCT 2006 42 100 51 7 203

NOV 2006 54 103 62 9 228

DIC 2006 18 48 26 1 93

TOTAL 356 999 854 80 2.309

PORCENTAGE 0,17 %#### 43,27 % 34,33% 3,46 %

The problem is that in one of the "PERCENTAGE" field the result is given as "####" instead of giving the real number and when i pass the cursor over that field, the real percentage appears, and it only happens with this field, every other field in the structure is shown as it should be.

Anyone have any idea??