The sum of the Household Income values do not equal 100% in a General Report for the Business Analyst Extension

Description

The General Report generated by Business Analyst is wrong. The sum of the household income values is not equal to 100%. This only occurs to the values of the second ring of a multi-ringed analysis.

Cause

The template used to generate the General Report has an error. The formula used to calculate the value of the household income for the range $50,000 - $74,999 references the value generated for the first ring.

Solution or Workaround

1. Navigate to the file Gerneral.rpt at $AVHOME\BUSINESS\REPORTS\summary with Windows Explorer.
2. Right-click on General.rpt and select Open.
3. Select 'Running Total Field...' under the Insert menu.
4. Scroll down and select 0028_HhldInc50-75K_R2.
5. Click the Edit button.
   
   
   
6. Click the 'Use a formula' button.
   
   
7. Copy and paste the following formula in the Running Total Condition Formula box:
   
   

   Code:
   {exp0.RING}=2

   
   
8. Close the Formula window.
9. Click OK in the Edit Running Total Field dialog.
10. Click Close in the Insert Fields dialog box.
11. Save the changes to General.rpt.