Edit

Share via

Formula Element

  • Article

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

<Formula>
  StringValue
</Formula>

Parent Elements

ExtendedAttribute

Occurrences

Minimum: 0

Maximum: 1

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