This is a migrated thread and some comments may be shown as answers.

Aggregate in footer by multiplication columns

3 Answers 9 Views
GridView
This is a migrated thread and some comments may be shown as answers.
Grzesiek
Top achievements
Rank 2
Grzesiek asked on 09 Jan 2019, 01:07 PM

     I have situation as below:

https://prnt.sc/m4wbkw

I have amount of cash in one column, and columns with teams. Each team can have some % in project.

Now I want to have in footer sum of the total amount which is multiply by % of each project.

 

Can someone help me? I've searched and there was nothing about multiplication.

 

Thanks.

3 Answers, 1 is accepted

Sort by
0
Dinko
Telerik team
answered on 14 Jan 2019, 09:45 AM
Hello Grzesiek,

Thank you for the screenshot but I think I still need a little more guidance about your scenario. I missing the point which column by which is multiplied. I have created a sample project and attached to this reply. Can you take a look and let me know what I need to so I can mimic your implementation? This way I could better understand it.

Regards,
Dinko
Progress Telerik
Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
0
Grzesiek
Top achievements
Rank 2
answered on 16 Jan 2019, 07:56 AM

Hello Dinko,

Please look at screenshot. This is what we have already in Excel files. I need to make the same table as Grid:

http://prntscr.com/m7tghs

0
Dinko
Telerik team
answered on 16 Jan 2019, 12:32 PM
Hello Grzesiek,

Thank you for the provided picture.

What you could try is to calculate the value on data level and applied it to a property in the ViewModel. Then you can specify a TextBlock in the footer of the column and bind the Text property to this custom one. I have modified the project to demonstrate this.

As a side note, if I have understood the formula is it every cash of the team multiply by the percent inside the column and sum all values. Correct me if I am wrong.

Regards,
Dinko
Progress Telerik
Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
Tags
GridView
Asked by
Grzesiek
Top achievements
Rank 2
Answers by
Dinko
Telerik team
Grzesiek
Top achievements
Rank 2
Share this question
or