I am using a Calculated field in an UltraWebGrid and know how to set it up to create a the Grid Totals.
One of my columns is a percentage column and the correct footer value is not the sum of the percentage values, rather it is (sum(col3) / sum(col1)). Is there a document for building the UltraCalc fomula for use in this footer field?
Hello Raj,Please take a look at the following link of our online help- http://help.infragistics.com/NetAdvantage/ASPNET/2011.1/CLR4.0/?page=WebCalcManager_Creating_a_Calculated_Summary_in_WebGrid.html I would also advise you to start migrating to the new Aikido grids since the old ones are retired in the latest versions of NetAdvantage.
The link shows an example of the sum() formula. I need a link to a more comprehensive list of formulae. Specifically I need to be able to enter the equivalent of (sum(col3) / sum(col1)). Entering this does not seem to have any effect therefore I am looking for the correct syntax.
Hello Raj,Please take a look at the attached sample. You will have to download Nwind.mdb from the following link - http://www.microsoft.com/en-us/download/details.aspx?id=19704 and place it in App_Data folder in order to run the sample.
Hello Raj,Please let me know if you have any further questions regarding this issue.
I cannot access the database file that you have linked to. The Microsoft site shows an error when clicking the link.
I looked at the code in the .cs file and it shows how to do a count and sum.
I have moved on from this as other higher priority projects are taking precedence. I'll get back if and when I need to use UltraCalc again.
Hello raj_sainThank you for your feedback. It seems the Microsoft have removed this page. When you came back to this issue and if you need to see the sample running i will create a support ticket and send the whole sample to you through this support ticket.