How to insert a formule from the work item field?

Topics: Developer Forum, Project Management Forum, User Forum
Aug 19, 2009 at 5:40 PM

How to insert a formule from the work item field?

Ex:

Custom.IQS=(100-(([Custom.Nonconformity]*10)/([Custom.Code]/1000)))/100

<?xml version="1.0" encoding="utf-8"?>
<WITD application="Work item type editor" version="1.0">
  <WORKITEMTYPE>
    <DESCRIPTION>Includes information about a particular impediment</DESCRIPTION>
    <FIELDS>
      <FIELD refname="System.Id">
        <HELPTEXT>Human readable, auto-populated numeric Id</HELPTEXT>
      </FIELD>
      <FIELD reportable="measure" refname="Custom.Nonconformity">
        <HELPTEXT>Nonconformity</HELPTEXT>
      </FIELD>
      <FIELD reportable="measure" refname="Custom.Code">
        <HELPTEXT>Code Line</HELPTEXT>
      </FIELD>
      <FIELD reportable="measure" refname="Custom.IQS">
        <HELPTEXT>IQS</HELPTEXT>
      </FIELD>
    </FIELDS>
   
    <FORM>
      <Layout>
        <Group Label="IQS Information">
          <Column PercentWidth="50">
            <Group>
              <Column PercentWidth="100">
                <Control FieldName="Custom.Nonconformity" Label="Nonconformity:" LabelPosition="Left" />
                <Control FieldName="Custom.Code" Label="Code Lines:" LabelPosition="Left" />
              </Column>
            </Group>
          </Column>
          <Column PercentWidth="50">
            <Group>
              <Column PercentWidth="100">
                <Control FieldName="Custom.IQS" Label="IQS:" LabelPosition="Left" ReadOnly="True" />
              </Column>
            </Group>
          </Column>
        </Group>
      </Layout>
    </FORM>
  </WORKITEMTYPE>
</WITD>