Data Dictionary: | Single Location Demographic Report |
Data Source: |
T017. | 2028 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 (ORG2028:MEDHHINC==0)
oretval = 0;
else if (ORG2028:MEDHHINC>0 && ORG2028:MEDHHINC<25000)
oretval = (ORG2028:HOUSEHOLDS7*24999)/(2*ORG2028:MEDHHINC);
else if (ORG2028:MEDHHINC>24999 && ORG2028:MEDHHINC<35000)
oretval = ORG2028:HOUSEHOLDS7/2-(ORG2028:MEDHHINC-25000)*ORG2028:HH25_35/9999;
else if (ORG2028:MEDHHINC>34999 && ORG2028:MEDHHINC<50000)
oretval = ORG2028:HOUSEHOLDS7/2-ORG2028:HH25_35-(ORG2028:MEDHHINC-35000)*ORG2028:HH35_50/14999;
else if (ORG2028:MEDHHINC>49999 && ORG2028:MEDHHINC<75000)
oretval = ORG2028:HOUSEHOLDS7/2-(ORG2028:HH25_35+ORG2028:HH35_50)-(ORG2028:MEDHHINC-50000)*ORG2028:HH50_75/24999;
else if (ORG2028:MEDHHINC>74999 && ORG2028:MEDHHINC<100000)
oretval = ORG2028:HOUSEHOLDS7/2-(ORG2028:HH25_35+ORG2028:HH35_50+ORG2028:HH50_75)-(ORG2028:MEDHHINC-75000)*ORG2028:HH75_100/24999;
else if (ORG2028:MEDHHINC>99999 && ORG2028:MEDHHINC<125000)
oretval = ORG2028:HOUSEHOLDS7/2-(ORG2028:HH25_35+ORG2028:HH35_50+ORG2028:HH50_75+ORG2028:HH75_100)-(ORG2028:MEDHHINC-100000)*ORG2028:HH100_125/24999;
else if (ORG2028:MEDHHINC>124999 && ORG2028:MEDHHINC<400000)
oretval=(ORG2028:HOUSEHOLDS7*125000)/(ORG2028:MEDHHINC+125000)-(ORG2028:HH25_35+ORG2028:HH35_50+ORG2028:HH50_75+ORG2028:HH75_100+ORG2028:HH100_125);
else if (ORG2028:MEDHHINC>399999 && ORG2028:MEDHHINC<1000000)
oretval=(ORG2028:HOUSEHOLDS7*(250000+ORG2028:MEDHHINC))/(4*ORG2028:MEDHHINC+250000)-(ORG2028:HH25_35+ORG2028:HH35_50+ORG2028:HH50_75+ORG2028:HH75_100+ORG2028:HH100_125);
if (oretval<0)
oretval = 0;
if (ORG2028:HOUSEHOLDS7.IsNull || ORG2028:HH25_35.IsNull || ORG2028:HH35_50.IsNull || ORG2028:MEDHHINC.IsNull || ORG2028:HH50_75.IsNull || ORG2028:HH75_100.IsNull || ORG2028:HH100_125.IsNull)
oretval.IsNull = true;
return oretval;
|