Data Dictionary: | Single Location Demographic Report |
Data Source: |
T017. | 2027 Households by Income | |||||||||||||||||
Universe: none | ||||||||||||||||||
T017_002Households with Income Less than $25,000 (Estimates) *
Percent base:
None - percentages not computed (variable is table universe)
Aggregation method:
Addition
Formula used to compute this variable:
#ReturnType oretval = new #ReturnType();
if (ORG2027:MEDHHINC==0)
oretval = 0;
else if (ORG2027:MEDHHINC>0 && ORG2027:MEDHHINC<25000)
oretval = (ORG2027:HOUSEHOLDS7*24999)/(2*ORG2027:MEDHHINC);
else if (ORG2027:MEDHHINC>24999 && ORG2027:MEDHHINC<35000)
oretval = ORG2027:HOUSEHOLDS7/2-(ORG2027:MEDHHINC-25000)*ORG2027:HH25_35/9999;
else if (ORG2027:MEDHHINC>34999 && ORG2027:MEDHHINC<50000)
oretval = ORG2027:HOUSEHOLDS7/2-ORG2027:HH25_35-(ORG2027:MEDHHINC-35000)*ORG2027:HH35_50/14999;
else if (ORG2027:MEDHHINC>49999 && ORG2027:MEDHHINC<75000)
oretval = ORG2027:HOUSEHOLDS7/2-(ORG2027:HH25_35+ORG2027:HH35_50)-(ORG2027:MEDHHINC-50000)*ORG2027:HH50_75/24999;
else if (ORG2027:MEDHHINC>74999 && ORG2027:MEDHHINC<100000)
oretval = ORG2027:HOUSEHOLDS7/2-(ORG2027:HH25_35+ORG2027:HH35_50+ORG2027:HH50_75)-(ORG2027:MEDHHINC-75000)*ORG2027:HH75_100/24999;
else if (ORG2027:MEDHHINC>99999 && ORG2027:MEDHHINC<125000)
oretval = ORG2027:HOUSEHOLDS7/2-(ORG2027:HH25_35+ORG2027:HH35_50+ORG2027:HH50_75+ORG2027:HH75_100)-(ORG2027:MEDHHINC-100000)*ORG2027:HH100_125/24999;
else if (ORG2027:MEDHHINC>124999 && ORG2027:MEDHHINC<400000)
oretval=(ORG2027:HOUSEHOLDS7*125000)/(ORG2027:MEDHHINC+125000)-(ORG2027:HH25_35+ORG2027:HH35_50+ORG2027:HH50_75+ORG2027:HH75_100+ORG2027:HH100_125);
else if (ORG2027:MEDHHINC>399999 && ORG2027:MEDHHINC<1000000)
oretval=(ORG2027:HOUSEHOLDS7*(250000+ORG2027:MEDHHINC))/(4*ORG2027:MEDHHINC+250000)-(ORG2027:HH25_35+ORG2027:HH35_50+ORG2027:HH50_75+ORG2027:HH75_100+ORG2027:HH100_125);
if (oretval<0)
oretval = 0;
if (ORG2027:HOUSEHOLDS7.IsNull || ORG2027:HH25_35.IsNull || ORG2027:HH35_50.IsNull || ORG2027:MEDHHINC.IsNull || ORG2027:HH50_75.IsNull || ORG2027:HH75_100.IsNull || ORG2027:HH100_125.IsNull)
oretval.IsNull = true;
return oretval;
|