Hey Mike, I've used so many of your posts that it is nice that you are the one responding to my first.

I had previously tried something like what you suggest (but did not want to write a novel in the initial post) where I created a method called from the form load event.  The method contained these 4 lines"

Infragistics.Win.UltraWinCalcManager.CalcSettings calcSettings = new Infragistics.Win.UltraWinCalcManager.CalcSettings();
calcSettings.PropertyName = "GrossRetMTD";
calcSettings.TreatAsType = typeof(double);
this.ultraCalcManager1.SetCalcSettings(this.numGrossRetMTD, calcSettings);

Seeing your post I immediately thought that the issue was with the formula because I had forward slashes in front of the control name, not backslashes in your emample above.  [//numGrossRetMTD] vs. [\\numGrossRetMTD].

It does not work as I get #REF! in each cell with the formula.  The interesting part is when I do have forward slashes before the control name  [//numGrossRetMTD]  I get a validation prompt (flashing red exclamation point) on the  numGrossRetMTD control that states, "PropertyName not set or property not found on CalcSettings".  This tells me that the forward slashes are correct, so I changed the four lines above to what you suggested:

CalcSettings calcSettings = this.ultraCalcManager1.GetCalcSettings(this.ultraNumericEditor1);
calcSettings.PropertyName = "Text";
calcSettings.TreatAsType = typeof(double);

This works on the intial load (yea!) but upon changing the value in ultraNumericEditor1, I now get an immediate validation prompt, "Input String was not in a correct format"...?  I get no such prompt when I comment out the code to add the control to the CalcNetwork.  What next?  We're close!

Regards, Jaime

To summarize as a solution to adding calc manager formulas to grid columns with other control values as participating in the formulas:

First add the other controls (in this case an ultraNumericEditor) to the CalcNetwork in the contructor or form load event:  ("Value" is the ultraNumericEditor1.Value property)

CalcSettings cs = new CalcSettings();
cs.PropertyName = "Value";
cs.TreatAsType = typeof(double);
this.ultraCalcManager1.SetCalcSettings(this.ultraNumericEditor1, cs);

cs = new CalcSettings();
cs.PropertyName = "Value";
cs.TreatAsType = typeof(double);
this.ultraCalcManager1.SetCalcSettings(this.ultraNumericEditor2, cs);

Now wire your grid to ultraCalcManager1 in the InitializeLayout event:

this.ultraWinGrid.CalcManager = this.ultraCalcManager1;

Finally, set a formula on a given column in the same InitializeLayout event: (*Note the reference syntax to your control containing the value to partcipate in the calculation uses forward slashes [//ultraNumericEditor1])

e.Layout.Bands[0].Columns["MyDataSetColumnName"].Formula = "( ROUNDUP((([OtherColumnNameInGridWithNoQuotesHere] * [//ultraNumericEditor1]) * 100),2) )";

Regards, Jaime

Solved!  Changed calcSettings.PropertyName to "Value" (of the control) not "Text" and the validation errors are gone and the calculations in both grids update upon changing the text in the control.

Mike, thanks again - you led me down the right path.

More on the numeric editor validation prompt mentioned at the end of my last post - The pesky red exclamation point icon goes away when focus leaves the control and the #Ref! in each column also resolve to properly calculated values using the new value in the numeric editor, but only after I click one of the cells in each column.  There must be an easy way to remedy each of these.  Thanks again, Jaime