Versions Compared

Key

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

...

  • IF a rule exists on this line

  • ELSE if no rules above match, use this result

  • $value_type value type name

  • $empty special handler for empty values

  • == equals

  • != does not equal

  • AND links multiple conditions

  • THEN result follows

  • + concatenate with another value type or text

...

  1. If the row is the top-up summary row, then return the total value ($total); otherwise

  2. If the row is the paid breaks summary row, then return the number of hours ($hours); otherwise

  3. If the row is a contract timesheet entry, then return the unit rate ($unit_rate); otherwise

  4. Return the hourly rate ($hourly_rate)

Example 4

Code Block
IF $location__division != $empty THEN $location__division
IF $client__division != $empty THEN $client__division
IF $row_type == timesheet_entry THEN No Division
  1. If the row has a Location Division, then return its name

  2. If the row has a Client Division, then return its name

  3. If the row is a timesheet entry return the text “No division”

  4. Otherwise, return nothing