Derived Field: coll_recovery_rate
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: