Hi,
I have assigned a UltraWinCalcManager to a WinGrid to calculate a Weighted Average of a column.
I have set the CalcFrequency to 'Manual'. The calculation is triggered by the following code...
cm.DirtyAllFormulas(); cm.ReCalc(); where cm is a CalcManager.
<Message>Object reference not set to an instance of an object.</Message> <Source>Infragistics2.Win.UltraWinCalcManager.v7.1</Source> <HelpLink /> <Property name="Data">System.Collections.ListDictionaryInternal</Property> <Property name="TargetSite">Boolean CleanTopologicalEventQueue(Int64)</Property>
at Infragistics.Win.CalcEngine.UltraCalcEngine.CleanTopologicalEventQueue(Int64 ticks) at Infragistics.Win.CalcEngine.UltraCalcEngine.Recalc(Int64 ticks) at Infragistics.Win.UltraWinCalcManager.UltraCalcManager.ReCalcInternal(Int64 ticks) at Infragistics.Win.UltraWinCalcManager.UltraCalcManager.ReCalc(Int64 millis) at Infragistics.Win.UltraWinCalcManager.UltraCalcManager.ReCalc()
Is this a bug? is there any hot fixes for this?
This does happen randomly since I don't get this everytime.
Kai
Thanks for your response Kailaw. The extra unbound column is indeed a possible workaround, but I need to caculate the weighted average for more then 80 columns in the grid. The trick with the unbound column would mean that we need to add 100 unbound columns. I was wondering if there would not be a single summary formula that could be used to do the trick without unbound column. Similar to the SUMPRODUCT() formula found in Excel.
Rgds, Bart
Hi Kai,
I'm also in the need of calculating a weighted average for several dunamic columns but could not find the formula that did the thing. I finally implemented the ICustomSummaryCalculator to calculate myself the weighted average. I would be intrested to see what formula expression you used to calculate the weighted average with the UltragridCalcmanager. I tried as formula "sum([Quantity]*[Moisture]) / Sum([Quantity]) " but I get an error on that one.
Michel
I've never seen that error message before. Do you have the latest Hot Fix?