English

Problem: 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

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:

    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.