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
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
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