If the following 'variables' are defined: (These 'variables' can be any information that is recorded on the Part Record)

• A = 12
• B = 15
• C = 2
• D = 18.123
• E = Hello
• F = World
• G = 3/31/2002 12:00:00 AM
• H = 5/2/2002 12:00:00 AM
• [NOW] = -- Current Date --  (01-06-2011)

Note: Formulas are not case sensitive

You can use these 'variables' in formulas, like as shown in the following examples:

• 1+2 -> 3
• [E] + ' ' + [F] + ' !' -> Hello World !
• IIF([A]>[D],[E],[F]) -> World
• Format('dd-MM-yy', Now()) -> 17-02-09
  • More Examples : http://msdn.microsoft.com/en-us/library/8kb3ddd4.aspx
• Format('f',[D]) -> 18.123
• Format('f1',[D]) -> 18.1
• Format('f2',[D]) -> 18.12
• Format('f4',[D) -> 18.1230
• Convert('tostring',[E]) -> 'Hello'
• format('MM-dd-yyyy', convert('todatetime',[NOW]+3*)) -> 01-09-2011

Math

• IIF([A] = [A], True, False)  -> True
• IIF([A] != [A], True, False)  -> False
• [A] = [A] -> True
• [A] != [A] -> False
• [B] - [A] -> 3
• [B] - [A] -> 27
• [A] * [C] -> 24
• [A] / [C] -> 6
• Example for a AND Type operation
• IIF([A] = [A], IIF([B] = [B], True, False), False) -> True
• IIF([A] = [A], IIF([B] = [C], True, False), False) -> False
• Example for a OR Type operation
• IIF([A] = [A], True,IIF([B] = [B], True, False)) -> True
• IIF([A] = [A], True,IIF([B] = [C], True, False)) -> True
• IIF([A] = [C], True,IIF([B] = [B], True, False)) -> True
• IIF([A] = [C], True,IIF([B] = [C], True, False)) -> False

Functions

You can use the following function in the formulas:

• sin(), cos(), pi()
• sqrt()
• abs()
• iff()
• max(), min(), 
• ln()
  • Natural logarithm, where the base is 'e'.
• log()
  • Logarithm where the base can be selected, example log(2,10) where the logarithm of 2 is calculated with base 10.
• med()
  • Calculated the median of the provided variables, example syntax med([VARA],[VARB],[VARC],[VARD],...)
• stdev()
  • 
  • where Σ = Sum of
    X = Individual values
    M = Mean values
    N = Sample size (Number of values)
• stdevp()
  • 
  • where Σ = Sum of
    X = Individual values
    M = Mean values
    N = Sample size (Number of values)
• CONVERT('see below', value)
  • tobool
  • toint
  • todouble
  • todatetime
  • tostring
• left()
  • Needs a string and a number: left([T],[N]).
  • For example left('Hello',2) will give back the string 'He'.
  • Variables can be used as well, so left([E],[C]), using the configuration above, will give back 'He' as well.
• right()
  • Needs a string and a number: right([T],[N]).
  • For example right('Hello',2) will give back the string 'lo'.
  • Variables can be used as well, so right([E],[C]), using the configuration above, will give back 'lo' as well.
  • For example to do a translation of the most right number in a string to text, the following example can be used
    • IIF(right([T],[N])='6','Six','Not Six'), where T is the text, and N should be the number 1.
• mid()
  • Needs a string followed by two numbers: mid([T],[P],[N]). Where the first number is the position, and the second number is the length.
  • For example mid('Hello',2,3) will give back the string 'llo'.
  • Variables can be used as well, so mid([E],[C],[C]+1) will give back the string 'llo' as well.
• rand()
  • Create random numbers, rand(1,8) for example will create random numbers starting at 1, and ending at 8.
   

Useful Links

Click one of the following links to learn more:

• How to add a calculated value NV to a Step Definition
• Calculated NV example