Sum of average in Tablix

Sum of average in Tablix

Posted by: ela.yudhanira on 4 October 2023, 7:25 pm EST

• 

  ela.yudhanira

  • Post Options:
  • Link
    Copy

  Posted 4 October 2023, 7:25 pm EST - Updated 4 October 2023, 7:30 pm EST

  Hi,
  
  I have a tablix table where I want to calculate average of each bounded data value. And then I want to calculate sum of the average. (image attached).
  
  How can I do that? Seems like the formula I added is not doing what it supposed to do. When I added {Avg(SalesAmount)}, it will calculate average of all SalesAmount. Can I do something like Sum(“select bounded data average column”)

  

  934×374 25.4 KB

• 

  akshay.rajput

  

  • Post Options:
  • Link
    Copy

  Posted 5 October 2023, 7:26 pm EST

  Hi Ela,

  Unfortunately, it is not possible to aggregate complex expressions like this without modifying the data structure. However, if you could share a sample report with some dummy data then we can check what specific changes you can make to show sum of the averages.

• 

  sergey.abakumov

  

  • Post Options:
  • Link
    Copy

  Posted 5 October 2023, 8:37 pm EST

  Hello,
  
  Based on the attached image, it seems the report corresponds to the Drill-Down Tablix sample found here: https://www.grapecity.com/activereportsjs/demos/Reports/DrillDownTablix/purejs.
  
  If that’s the case, {Avg(SalesAmount)} will represent the average sales amount for a particular year or month.
  
  I’m curious about the rationale behind displaying the sum of these average values. Could you shed some light on the intent behind this?