Field Details: coll_settlement_discount

Back to Fields
Basic Information
Field Name: coll_settlement_discount
Source Table: evolved_records
Version: 1
Expression Type: jinja
Output Type: FLOAT
Status: Active
Created: 2025-10-16 04:31:29
Updated: 2025-10-16 04:31:29
Metadata
Display Name: Settlement Discount (%)
Categories: COLLECTIONS
Group: Settlement Metrics
Usage
Used in Summary: Yes
Used in Template: No

Description

No description available

Expression

            {% if raw_data.transaction_type == "SETTLEMENT" or raw_data.subcategory == "RURAL_SETTLEMENT" or raw_data.subcategory == "URBAN_SETTLEMENT" %}
                {% set total_outstanding = raw_data.total_outstanding|default(0) %}
                {% set settlement_amount = raw_data.settlement_amount|default(0) %}
                
                {% if total_outstanding > 0 and settlement_amount > 0 %}
                    {{ ((total_outstanding - settlement_amount) / total_outstanding * 100)|round(2) }}
                {% else %}
                    0
                {% endif %}
            {% else %}
                0
            {% endif %}