You can use constants in derivation formulas for simple fields and for table field columns. For example, you can specify the derivation formula for Field_A as:

Supported data types for constants in derivation formulas are char, varchar, c, text, integer, floating point, date, and money. Specify dates, money, and non‑numeric strings in single quotation marks, as: