Home
Test Derived Field Expressions
Expression
Context & Results
Sample data to use when evaluating the expression
Result:
Type:
Sample Templates
{
"amount": 100,
"tax_rate": 0.10,
"customer_tier": "premium",
"transaction_date": "2023-05-15",
"customer_id": "CUST001",
"products": [
{"id": "PROD001", "name": "Widget A", "price": 25},
{"id": "PROD002", "name": "Widget B", "price": 75}
],
"discount": 15,
"transaction_id": "TXN12345"
}
{{ amount * tax_rate }}
{% if customer_tier == "premium" %}
{{ amount * 0.85 }}
{% elif customer_tier == "gold" %}
{{ amount * 0.90 }}
{% else %}
{{ amount * 0.95 }}
{% endif %}
Transaction #{{ transaction_id }}: {{ customer_tier|upper }} customer purchased items for ${{ "%.2f"|format(amount) }}
{% set date = transaction_date|string %}
{% set year = date.split('-')[0] %}
{% set month = date.split('-')[1] %}
{% set day = date.split('-')[2] %}
Transaction on {{ month }}/{{ day }}/{{ year }} - Quarter {{ ((month|int - 1) // 3) + 1 }}
{
"*": [
{"var": "amount"},
{"var": "tax_rate"}
]
}
{
"if": [
{"==": [{"var": "customer_tier"}, "premium"]},
{"*": [{"var": "amount"}, 0.85]},
{"if": [
{"==": [{"var": "customer_tier"}, "gold"]},
{"*": [{"var": "amount"}, 0.90]},
{"*": [{"var": "amount"}, 0.95]}
]}
]
}
{
"cat": [
"Transaction #",
{"var": "transaction_id"},
": ",
{"method": [{"var": "customer_tier"}, "toUpperCase"]},
" customer"
]
}
{
"and": [
{">": [{"var": "amount"}, 50]},
{"in": [{"var": "customer_tier"}, ["premium", "gold"]]},
{"some": [
{"var": "products"},
{">": [{"var": ".price"}, 30]}
]}
]
}