Field Details - coll_recovery

Field Details: coll_recovery_rate

Basic Information

Field Name:	`coll_recovery_rate`
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:	Recovery Rate (%)
Categories:	COLLECTIONS
Group:	Collection Metrics

Usage

Used in Summary:	Yes
Used in Template:	No

Description

No description available

Expression


            {% set total_due = coll_total_due|default(0) %}
            {% set collected = raw_data.collected_amount|default(0) %}
            
            {% if total_due > 0 %}
                {{ (collected / total_due * 100)|round(2) }}
            {% else %}
                0
            {% endif %}

Dependencies

coll_total_due