The summary function min and max limits of tables in Empower Publisher are fixed at 4 dp - WKB319177

SYMPTOMS

• In Empower Report Publisher, the min and max limits of the summary function in report tables are fixed at four decimal places (dp)
• Specified 0.99 becomes 0.9900
• Specified 0.999 becomes 0.9990
• Specified 0.99999 becomes 1.0000

ENVIRONMENT

• Empower
• Report Publisher
• Summary functions of report tables

CAUSE

Not a defect; it was implemented this way.

FIX or WORKAROUND

None. Specify a limit value as close as possible to the value you require (for example, for 0.999 enter 0.9985).

• Instead of adding summary fields to a report table, use summary custom fields and set suitability limits on these fields in the processing method.
• Report summary fields and whether they are within the limits are not stored in the database. They only exist in the report.

ADDITIONAL INFORMATION

Raised CRI-9169, which confirmed this is working as designed. 

Design Intent:

Custom Fields in Empower

• Are fully configurable for precision and logic.
• Stored in the database, so they are part of the validated method.
• Allow users to apply their own rounding or calculation rules.
• Can be included in compliance checks and reports with complete traceability.

Report Table Limits

• Were designed as a quick, non-validated reporting feature, not as a primary compliance mechanism.
• Settings are not stored in the database, so they do not carry the same audit trail or validation assurance.
• Fixed at 4 dp to keep the feature simple and consistent across all installations.