http://help.infragistics.com/Help/Doc/WPF/2014.2/CLR4.0/html/InfragisticsWPF4.Calculations.XamCalculationManager.v14.2~Infragistics.Calculations.Engine.ICalculationFormula~FormulaString.html

Note: you might also want to check out the xamFormulaEditor. The dialog it pops up lists all of the built in functions or you could call the xamCalculationManager's GetAllFunctions() method. You can also register custom functions via the RegisterUserDefinedFunction or RegisterUserDefinedFunctionLibrary methods.

Hi Steve,

Yes you can implement running totals easily since the formula supports relative references. Here is an example of a running total for 'Prop1':

Formula="IF( IsError( [RunningTotal(-1)]), [//StartingValue], [RunningTotal(-1)] + [Prop1])" 

Note: that the 'IF' function takes 3 parameters:

1. The test condition: in this case IsError([RunningTotal(-1)]). This is needed because the first record doesn't have anything above it.
2. The value to return if the condition above is true, in this case [//StartingValue]. This can be any reference, formula or a constant value like 0.
3. The value to return if the condition above is false, in this case [RunningTotal(-1)] + [Prop1].

Also be aware that there is a property exposed off FieldLayoutSettings named CalculationScope that governs which record references are returned when using these relative indices. The possible values are:

• FilteredSortedList - default
• FullSortedList
• FullUnsortedList

I hope this helps.