Infragistic 7.1 Exception when doing calculation...

State See Verified Answer
Replies 4 replies
Subscribers 7 subscribers
Views 1107198 views
Users 0 members are here

UltraCalcManager

275

Kai posted over 16 years ago

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.

So my problem is, sometimes when I trigger the calculation, I get the following exception.

<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

Parents

25

Bart posted over 16 years ago

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

Cancel
275

Kai posted over 16 years ago in reply to Bart

I have to create an unbound column and then initialize the value in the initialize row event. so in your case, you will need to create an unbound column for Quantity * Moisture and then in the summary, you can do SUM()/sum(quantity) Hope that helps.
Cancel
Reply

Cancel

Reply

25

Bart posted over 16 years ago in reply to 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
Cancel
Reply

Cancel

Children

No Data