---

Expression Process

1: variable assignment

2: the field of "Process" exist expression value

+ - * / ^ 

>   return 1 if true  return 0 if false

<   return 1 if true  return 0 if false

>=  return 1 if true  return 0 if false

<=  return 1 if true  return 0 if false

==  return 1 if true  return 0 if false

<> or !=   not equal return 1 if true  return 0 if false

>>  shift right n bit                 4.61168601842739E18>>62 =1

<<  shift left n bit  (n<=62) 1<<62 = 4.61168601842739E18

&&  AND test, return 1 if both result<>0  return 0 if one of data =0

||  OR test,return 1 if one of data <>0  return 0 if both of data =0

sin(), cos(), tan()

arcsin(), arccos(), arctanh()

ABS()

INT(1.6)=1

ROUND(1.4)=1

ROUND(1.5)=2

ROUND(2.5)=2

ROUND(3.5)=4

FRAC(1.6)=0.6

EXP(1)=2.71828182845905

LOG10()

LOG2()

Ln()

x0210(1010)=10  bin to dec

x1610(10)  =16 hex to dec

AND

OR

XOR

nnnnn.b =binary of (nnnn)

• MIN(v1,v2,v3....)
  
  take minimum value from those values.
  v1,v2,... could be an expression also
  example: MIN(1,2,3) =1
• MAX(v1,v2,v3....) 
  take maximum value from those values.
  v1,v2,... could be an expression also
  example: MAX(1,2,3) =3 
  example: MAX(['&VAR:v1'], ['&VAR:v2'], ['&VAR:v3']+900)
• AVG(v1,v2,v3....) 
  calculate the average value from those values.
  v1,v2,... could be an expression also
  example: AVG(1,2,3)=2
• CNT(v1,v2,v3....)
  return the total count of variable

  example: AVG(1,2,3,5)=4
• STDEVP(v1,v2,v3....)  //ITTS only
  

  calculate The "Population Standard Deviation

  example: STDEVP((1,2,3,4,5,6,7,8,9,10)=2.872281
  

  
• STDEVS(v1,v2,v3....) //ITTS only
  

  calculate The "Sample Standard Deviation"
  

  example: STDEVS(1,2,3,4,5,6,7,8,9,10)=3.02765
  

  
• STDEVS  (=STDEV excel 2007 or earlier)
  會假設它的引數為母體樣本。
  如果您的資料代表整個母體，則必須 STDEV.P 來計算標準差。
  標準差的計算是採用 "n-1" 方法。 
• STDEVP
  會假設它的引數是整個母體。
  如果您的資料代表母體的樣本，
  則使用 STDEV 來計算標準差。
  對於較大的樣本，STDEV 與 STDEVP 會傳回大致相等的值。
  標準差的計算是採用 "n" 方法。
• SORT(v1,v2,v3....);    //ITTS only  this is an experimental formula please don't use.
  sorting from low to highexample: SORT(10,2,3,9,7,4,5,6,8,1)=1,2,3,4,5,6,7,8,9,10
• POS(sub_str,main_str,v_start_search_pos)
  search the sub string's position match in main string, search position starting form v_start_search_pos, ignore v_start_search_pos search will starting form 1
  sub_str and main_str only support smart format, (not support expression)
  v_start_search_pos (support expression)

example: POS(ccc,aaabbbcccddd,1)=7

example: POS(["ddd"],["aaabbbcccddd"]) =10

 

SIN()

COS()

TAN()

ARCCOS()  ARCCOS(0) = 1.5707963267949   =  (pi/2)

ARCSIN()  ARCSIN(1) = 1.5707963267949   =  (pi/2)

ARCTANH()

 

0xFF=255

0xFFFFFFFF = -1  ( expression use sign int64 to convert )

0x80000000 = -2147483648  ( expression use sign int64 to convert )

0x7FFFFFFF = 2147483647

A=1+2+3+4    variable A=10

B:Str=ABCDE  string variable B=ABCDE

For this feature, you could direct assign some of result data to variable in same test item, don't to add additional test item assign the field value to variable

Example:

assign variable

a=100, 

str1:str=FF

 

['&VAR:A']+['&STR_VAR:str1':x1610([all])] +1 = 356