https://community.incorta.com/t5/administrative-discussions/sum-of-average-amount-grouped-by-approval-date/m-p/6376#M311 <P>Your requirement should be addressed by building insights over a result set.</P> <P>Building a result set is like creating an aggregate table insight, and the data will be available for building the insight.</P> <P>The result set in your case will have the AVERAGE(Amount_granted)&nbsp;<STRONG>grouped by (Approval Date column).&nbsp; The insight will sum the value returned from the result set.</STRONG></P> <P><STRONG>It is similar to write a SQL with the FROM clause subquery.</STRONG></P> <P><STRONG>Hope this help.</STRONG></P> Thu, 27 Mar 2025 13:50:08 GMT dylanwan 2025-03-27T13:50:08Z https://community.incorta.com/t5/administrative-discussions/sum-of-average-amount-grouped-by-approval-date/m-p/6223#M306 <P>How can I create a KPI with a formula that contains the following:&nbsp;</P><P><STRONG>SUM of AVERAGE(Amount_granted column) grouped by (Approval Date column)</STRONG></P><P><STRONG>i want the right formula that give me Total of average amount_granted group by approval date&nbsp;&nbsp;</STRONG></P> Thu, 02 Jan 2025 07:28:17 GMT https://community.incorta.com/t5/administrative-discussions/sum-of-average-amount-grouped-by-approval-date/m-p/6223#M306 Ahmad 2025-01-02T07:28:17Z https://community.incorta.com/t5/administrative-discussions/sum-of-average-amount-grouped-by-approval-date/m-p/6376#M311 <P>Your requirement should be addressed by building insights over a result set.</P> <P>Building a result set is like creating an aggregate table insight, and the data will be available for building the insight.</P> <P>The result set in your case will have the AVERAGE(Amount_granted)&nbsp;<STRONG>grouped by (Approval Date column).&nbsp; The insight will sum the value returned from the result set.</STRONG></P> <P><STRONG>It is similar to write a SQL with the FROM clause subquery.</STRONG></P> <P><STRONG>Hope this help.</STRONG></P> Thu, 27 Mar 2025 13:50:08 GMT https://community.incorta.com/t5/administrative-discussions/sum-of-average-amount-grouped-by-approval-date/m-p/6376#M311 dylanwan 2025-03-27T13:50:08Z