Hi All,
I am using MVVM, and display records in xamGrid. I applied groping on one column and display average values of all the columns, for this i use SummaryRowSettings. it is working fine but i want customization in display of records
1- Remove “Average” text from within cells and put in first Company Name column.
2- Add checkbox at top of table to "show average" or not.
3- Add dropdown at top of table to "show Formating" of AverageSummaryOperand percentage or integer, in sample application i used three static columns (RSquared , IndicatorPercentile ,OverUnderValuation) and other all columns are auto generated. All columns have FormatString is %. But i want customizable.
I create a sample application for this and add an image for reference i used same display records that shown in attached image in code, with the name of Portfolio.
Regards
Sufyan
And want to disable the Sum symbol in column header when groping is applied and average is displayed, to restrict user checking any item (e.g. Sum, Count, etc)
I have some null values in database and in grid these values are empty. When average is calculated i don't include these empty values in average calculations.Suppose i have 4 rows in one group and this group contains only one row value. Currently system calculated average like this, Sum of values of all the rows and divided by no of all rows. But i want sum of only those rows that contains values and divided by no of rows that contains values, not all rows, and do not show 0.00% if all rows are empty. I have attached image in previous sample application for further clarification.
Hello Sufyan,
I have modified the sample, so now everything works as expected with the Average checkbox. As for the null reference when there is grouped column and you try to add summary, I have logged a development issue under ID: 142834 and I have also created a support ticket on your behalf: CAS-116269-D1G9H6 and have linked the development issue to it, so that you can get automatically updated, when a Service Release containing the fix is available for download. You can get the new version from our website’s “My IG”, “My Keys & Downloads” tags: https://es.infragistics.com/Membership/Default.aspx?panel=Downloads#Downloads
You can also monitor the support ticket’s progress through the “My Support Activity” tag: https://es.infragistics.com/Membership/MySupport.aspx
Hi Stefan,
Thank you so much for helping, can you help me more regarding some issues that i face during applying custom average summary settings. I attached sample application, I was applied custom average summary, they are working good without grouping and calculate correct average. But when i applied grouping "Apply Grouping" check box checked than these columns calculate wrong average, please look into it, and if i was applied "AverageSummaryOperand" built in function, its working good and calculate correct average with grouping and without grouping but i face only one problem "Avg" text is shown with all columns, how can hide that text and only average result shown like custom average settings. To see this behaviour please uncomment the "AverageSummaryOperand" object from "xamGrid1_ColumnAutoGenerated" event. Kindly look into it i modified the sample.
I want to show results as shown in snapshot.
1- Remove “Avg” text from within cells and put in first Company Name column. When "AverageSummaryOperand" is used.
Any update about my issues.
Any update ?????
Thank you for your feedback. I am glad that you resolved your issue and I believe that other community members may benefit from this as well.
Thanks again.
Thank you so much. This solution solved my problem.
I have modified your sample, so now it works as you want.
Hope this helps you.