An arithmetic formula of three arguments, ‘x’, ‘y’ and ‘z’, may be entered using the F(x,y,z) SQL element. This element will result in the appropriate SQL for the formula being generated after replacing the arguments ‘x’, ‘y’ and ‘z’ in the formula with the SQL for the arguments in the tree.
Columns or other expressions can be moved into the (empty) branches of the tree representing the arguments ‘x’, ‘y’ and ‘z’. The formula to generate SQL for is specified in the Properties panel. Double-click on F(x,y,z) or highlight it and click Properties to create or edit the desired formula.