The report summary level or field type is misconfigured.

Problem Explanation

Reports aggregate data based on grouping and field data types. Text fields won’t sum correctly.

Root Cause(s)

1. Formula fields returning text

2. Incorrect grouping level

3. Filters excluding records

Step-by-Step Solution

1. Verify field data type (Number/Currency)

2. Check report grouping hierarchy

3. Recalculate summaries

Edge Cases & Variations

1. Joined reports calculate separately

2. Row-level formulas override summaries

Common Mistakes to Avoid

1. Summarizing formula text fields

2. Ignoring report filters