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 %}
© SimSol Technologies and Services Private Limited