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…

@liya101 thank you for sharing this screenshot. I was able to re-create a table similar to yours and test out the calculations and it seems like I was able to get it to work as a KPI if I manipulated the calculation code a little bit. Here is how I calculated the same fields you provided the code fo…

Hi @mbradley I have created an analysis here in arena Incremental Sales When I was tryinng out the formula: ifelse({Mailed Count if control is present} =0,0,sum({Mailed Count if control is present} ,[{Campaign Parent}]) *min({Control Conversion Rate},[{Campaign Parent}])) it gives me the error N…

ah yes you are correct, unfortunately that is not allowed - it was not clear to me that the underlying fields in your table were also all calculated fields. However in your arena it does seem to be working as a KPI the way you ended up doing the calculations. I noticed the KPI was missing the same d…

Hi @mbradley Thank you so much for replying quickly :). Aplogies for not being clear. My challenge is I want these metrics at an aggregate level. We have campaign data at 2 aggregations - parent level and child level. I am trying to calculate the incremental sales at parent campaign level. Incr…

Hi @liya101 , Hope everything is well with you! Just checking in since this thread hasn’t received a response in a while. Were you able to find a workaround yourself or are you still trying to find a solution? If we do not hear back within the next 3 business days, I’ll go ahead and close out this t…

Hi, still trying to find a solution

Hi @liya101 , Sorry for the long delay in replying back. Just for clarification purposes, for the Dormant campaign example you provided, I saw in the control summary table that both of the conversion rates are 0%. I know you mentioned that one is 1.01% and the other 0%, but is that how it is intende…

Hi @WLS-Luis Thank you for your response. Dormant campaign was a hypothetical case. I am trying to get the incremental sales which is there in the summary table to also be in the topline KPI.

Hi @liya101 , The reason why the KPI number is different is because you are using the “Overall incremental Sales” calculated instead of “Incremental Sales Campaign” (Picture 1). Swapping them out should give you the intended number (Picture 2). [image] [image]

Hi @WLS-Luis Thanks for your reply, I am trying to get the sum of incremental sales campaign as the KPI. The KPI should be -255.15 [image]

Aggregations on KPI

Q&A

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

Aggregations on KPI

Related topics