Calculation Transformation Function allows end-users to write scripts to transform data. Input values represented as [F00N] Where N is a value number. For example calculation you can see above has got two input values [F001] and [F002]. The programming language used is very close to Pascal.
Calculation Examples:
1. Strings Concatenation
[F001] + [F002]
Or
Begin
Result:= [F001] + [F002];
End;
2. Adding one value to another
Begin
Result:= StrToFloat([F001]) + StrToFloat([F002]);
End;
2. If Statement
Begin
If [F002]='' then
Result:= 0
else If [F002]=0 then
Result:= 0
Else
Result:= StrToFloat([F001]) mod StrToFloat([F002]);
End;
3. Variables
Var MyVariable : integer;
Begin
MyVariable:=10;
Result :=StrToFloat([F001]) mod MyVariable;
end;