Home

Derived Field: coll_recovery_rate

Back to List Edit Test
Field Details

Field Name:

coll_recovery_rate

Source Table:

evolved_records

Status:

Active

Expression Type:

jinja

Output Type:

FLOAT

Version:

v1

Used In:

Summaries

Display Name:

Recovery Rate (%)

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
Field Type Actions
coll_total_due Derived View
Joins

No joins defined

Registry Information

No registry entry found

Version History

No version history available

Field Usage

Referenced by:

Loading...