I am trying to calculate a field Incremental Sales Which is Incremental Sales = Mailed Sales - Expected Sales We have two groups Mailed and Control Mailed sales is calculated as the sum of revenue of mailed converted customers . Expected Sales = Expected Number of conversions * Control Average…

Aggregations on KPI

Topic		Replies	Views
Aggregations when a metric includes Multiplication/division Q&A calculations , Business-Intelligence-Engineer	5	51	February 20, 2026
Pivot table Aggregation Q&A pivot-table , Business-Intelligence-Engineer	1	51	August 19, 2025
New to QS - Aggregating inside Calculated Fields for KPI Q&A calculations	14	884	June 22, 2023
Why control filter work for table level but do not work on KPI level Q&A analysis , filters , dashboard , filters-controls-and-parameters , Business-Intelligence-Engineer	12	128	December 31, 2024
Unable to use aggregates for KPI Q&A date , calculations , Business-Intelligence-Engineer , kpi	2	30	September 25, 2024