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