Examples of Derivation Formulas
The following formulas are valid derivation formulas for simple fields:
Field_3 ‑ Field_2
(Field_3 ‑ Field_1) * (Field_5 ‑ Field_4)
Field_2 + sum(TableField1[*].Column2)
Lastname + ',' + Firstname
'today' + '30 days'
'today' ‑ '1 yrs 2 mos 3 days 12 hrs 24 mins 14 secs'
The following formulas are valid derivation formulas for table fields:
(TableField_1.Column1 + TableField_1.Column2) /2
Order_items.price * Order_items.quantity
Order_items.price *.90