Formula Element

This content is outdated and is no longer being maintained. It is provided as a courtesy for individuals who are still using these technologies. This page may contain URLs that were valid when originally published, but now link to sites or pages that no longer exist.

The formula that Microsoft Office Project uses to populate a task custom field.

<Formula>
  StringValue
</Formula>

Parent Elements

Occurrences

Example

In the following example, the Test Duration task custom field uses the formula [Duration]*3. Because the value is calculated, the ValueGUID in the task is zero. The Value in the project summary task (task UID = 0) is 168 hours, 0 minutes, 0 seconds (PT in PT168H0M0S stands for Project Time, for internal use). The rollup to summary tasks is the sum of values in subtasks (RollupType = 3).

<ExtendedAttributes>
   <ExtendedAttribute>
      <FieldID>188743957</FieldID>
      <FieldName>Duration6</FieldName>
      <Alias>Test Duration</Alias>
      <SecondaryPID>255868973</SecondaryPID>
      <RollupType>3</RollupType>
      <CalculationType>1</CalculationType>
      <Formula>[Duration]*3</Formula>
   </ExtendedAttribute>
</ExtendedAttributes>
. . .
<Tasks>
   <Task>
      <UID>0</UID>
      <ID>0</ID>
      . . .
      <ExtendedAttribute>
         <FieldID>188743957</FieldID>
         <Value>PT168H0M0S</Value>
         <DurationFormat>21</DurationFormat>
         <ValueGUID>00000000-0000-0000-0000-000000000000</ValueGUID>
      </ExtendedAttribute>
   </Task>
</Tasks>

See Also

Concepts

ExtendedAttribute Elements and XML Structure

XML Schema for the ExtendedAttributes Element