Field Details: coll_total_due

Back to Fields
Basic Information
Field Name: coll_total_due
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: Total Amount Due
Categories: COLLECTIONS
Group: Collection Metrics
Usage
Used in Summary: Yes
Used in Template: No

Description

No description available

Expression

            {% set principal = raw_data.principal_amount|default(0) %}
            {% set interest = raw_data.interest_amount|default(0) %}
            {% set fees = raw_data.fees_amount|default(0) %}
            {% set penalty = raw_data.penalty_amount|default(0) %}
            
            {% if raw_data.total_outstanding is defined %}
                {{ raw_data.total_outstanding }}
            {% else %}
                {{ principal + interest + fees + penalty }}
            {% endif %}