When you click on a number in a Siera Report to open the drill-down report and nothing happens, the issue is often related to the way the field is built.
Root Cause
If the field in question is created using an arithmetic expression (such as addition, subtraction, multiplication, division), drill-down is not supported.
-
Example: A field built as
Opportunities Won/Total Opportunitieswill display correctly in the report but cannot be drilled down into.
-
-
Since drill-down depends on underlying raw records, calculated expressions break this mapping, leading to the issue.
Resolution
-
Check if the field is built using an arithmetic expression.
-
If yes, inform the client that drill-down is not supported on such fields.
-
If drill-down is needed, suggest using the base fields directly in the report instead.
Notes for Agents
-
This is a product limitation, not an error.
-
Escalate only if drill-down fails on a direct (non-expression) field.
