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.
Hi Stefan,
Thank you for your reply,I have some more problems, when i applied groping on industry column and checked "My Average Menu Text" from "NumQtrsLead" column than application through "NullReferenceException" and application crashed, and custom average not calculated, after applying grouping than same error is occured on sort any column, before grouping sorting working fine, and i want to apply this custom average calculation from "R.Squard" to onward columns. Auto generated column names are not fixed they changed based on data and condition that i have in my real application. I was applied style on SummaryRowSettings than equal sign (=) is shown to all columns i want to remove that equal sign, and when i change value from dropdown than i want to applied these changes on all grid columns including average summary results. Currently % and non % applied only on average summary results. I changed the sample application. kindly look into it. I shall be very thankful to you for this favor.
Hello Sufyan,
The sample I created for you is a guideline of how you can achieve your goals, if you need to implement any custom scenarios you can contact our Consulting Team. You can read more detailed information regarding this here in our web site:
http://d3.infragistics.com/services/consulting-services/
Thank you for your reply, when i applied groping on any column and checked, check box of "My Average Menu Text" from "NumQtrsLead" column than application through "NullReferenceException" and application crashed, and custom average not calculated, same error is occured on sort any column, before grouping sorting working fine, I was applied style on SummaryRowSettings than equal sign (=) is shown to all columns i want to remove that equal sign, In previous post i changed the sample application.Show averge is working fine without grouping when applied grouping on any column than the show average check box through "NullReferenceException". kindly look into it. Kindly solve these crashing errors, for custom implementation i will consult from your consulting team. I shall be very thankful to you for this favor.
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
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.
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.
Any update ?????
Any update about my issues.