Formula element (List)

Applies to: SharePoint 2016 | SharePoint Foundation 2013 | SharePoint Online | SharePoint Server 2013

Contains a formula used in the definition of a field.

<Formula>
</Formula>

Elements and attributes

The following sections describe attributes, child elements, and parent elements.

Attributes

None

Child elements

None

Parent elements

Occurrences

  • Minimum: 0
  • Maximum: 1

Example

The following example defines a calculated field containing a formula that multiplies the value of another field by 100.

<Field Type="Calculated" DisplayName="Field_Display_Name" 
  ResultType="Number" ReadOnly="TRUE" Name="Field_Internal_Name">
  <Formula>=Other_Field_Name*100</Formula>
  <FieldRefs>
    <FieldRef Name="Other_Field_Name"/>
  </FieldRefs>
</Field>