Home
Derived Fields
Error loading profile. Please try again.
Jinja2 expressions can access context variables directly by name and apply operations or filters:
{{ total_amount * 0.10 }}
Filters transform values and are applied using the pipe operator:
{{ amount|round(2) }}
Available custom filters include:
date_format: Format dates, e.g., {{ date|date_format("%Y-%m-%d") }}month_name: Convert month number to name, e.g., {{ month|month_name }}round_to: Round to specified precision, e.g., {{ number|round_to(2) }}percentage: Format as percentage, e.g., {{ ratio|percentage }}default_if_none: Provide default value, e.g., {{ value|default_if_none("N/A") }}You can use conditional expressions:
{{ "High Value" if amount > 1000 else "Standard" }}
For more complex logic, wrap in expressions:
{% set tier = "premium" if transactions > 10 else "standard" %}{{ tier }}
JSONLogic expressions are JSON objects that represent operations:
{"*": [{"var": "total_amount"}, 0.10]}
Use the var operator to access context variables:
{"var": "customer_name"}
Various comparison operators are available:
{">": [{"var": "amount"}, 1000]}
Combine conditions with logical operators:
{"and": [
{">": [{"var": "amount"}, 1000]},
{"<": [{"var": "amount"}, 5000]}
]}
Use the if operator for conditional logic:
{"if": [
{">": [{"var": "amount"}, 1000]},
"High Value",
"Standard"
]}