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

Last Published: April 25, 2020


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.


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

Change the reference value to the second ring.

You must have Crystal Reports installed in order to use this solution.

  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.

    [O-Image] Running total dialog box for Crystal Reports
  6. Click the 'Use a formula' button.
    [O-Image] Formula button for Crystal Reports
  7. Copy and paste the following formula in the Running Total Condition Formula box:


  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.

Article ID:000005033

  • Legacy Products

Receive notifications and find solutions for new or common issues

Get summarized answers and video solutions from our new AI chatbot.

Download the Esri Support App

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options