Versions Compared

Old Version 6

changes.mady.by.user Sara Sanguineti

Saved on

compared with

New Version Current

changes.mady.by.user Sara Sanguineti

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Values can be entered manually, selected from the corresponding drop-down list or inserted by clicking on a cell in the spreadsheet. When you click on a cell in the spreadsheet, the corresponding attribute is added in the formula, with the format $"attribute_name". Functions and operators can also be used to define the formula.

Process variables can also be used in formulas. They are recognized by the "@" prefix. For example, @Today could be a process variable that contains the current date. For more information on process variables see Using Process Variables in Rulex.

Tip

Copying & pasting formulas

Formulas can be copied and pasted from a column to another, by right-clicking the column header and selecting Copy Formula. Then you select the target columns, right click and select Paste Formula. The attributes in the formula are automatically "shifted".

For example, if new_attribute_1 is defined $defined $"new_attribute_1" = $"attribute_name_1"+1 and we copy and paste this formula into new_attribute_2 (where new_attribute_2 is the attribute immediately after new_attribute_1 in the attribute list) then the pasted formula will be $"new_attribute_2" = $"attribute_name_2"+1 where attribute_name_2 is the attribute immediately after attribute_name_1 in the attribute list.

If you don't want the attributes to be "shifted" you can just put an extra '$' before the attribute name. For example, if you copy the formula $formula $"new_attribute_1" = $$"attribute_name_1"+1, then the pasted formula in new_attribute_2 will be $be $"new_attribute_2" = $$"attribute_name_1"+1. Of course, in a single formula you can insert both attributes with a single '$' and attributes with a double '$'.

...

Info

Selecting multiple attributes

  • If you need to select more than one attribute at a time, you can use either press Ctrl and select all the required attributes: ($"att1", $"att5", $"att11")

  • If you need to select a range of attributes, you can either press Shift and select the first and last attribute in the range, or select them all with the cursor. The formula bar will include a colon to indicate the range: $"att1":$"att5"

Examples of multiple selection syntax:

  • $"att_sum" = sum($"att1",$"att5", $"att11")

  • $"att_sum" = sum($"att1":$"att5")