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
0
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
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
Iron
Rank 2
Iron
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
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
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.