Rules & Calculation Formulas · Abstract rulesOperational Master Data RepositoriesRules & Calculation Formulas
Refund deviation from the average
AR-7- Draft
- Version
- v1
- Computed by
- FN-4 · Ratio
- Implemented rules
- 1
How many times the average refund a request is; far above 1 flags it for a second look.
Formula
Refund to average ratio = Refund requested ÷ Average refund
Example: 3,200 ÷ 1,326.33 = 2.41
- Output
- Refund to average ratio (×)
- Rounding
- FN-13 · 2 decimals
- Policy
- Proposal from the Q3 refund review
- Owner
- Lina Saleh
- Approved by
- —
| Parameter | Kind |
|---|---|
| Refund requested numerator | number |
| Average refund denominator | number |
Implemented rules
Where each rule is used, and with what: every parameter mapped to its source (which price, in which table and record) and the workflow, step or service that uses it.
Used in: Workflow WF-3 · Proposed check before Finance approval
Refund requested V-5 Refund amount requested {work case}!amountAverage refund V-14 Average refund requested = IR-6 Average refund · latest 25 refund cases