Executed rule: Average refund · latest 25 refund cases

RX-9

Monthly refund monitoring

Context

Average refund requested = SUM() ÷ COUNT()

= 975.36 EGP

Click a term to unfold it in place; the i shows where a source value lives.

The values this execution used, each with the cell it was read from.

Click a term to unfold it in place; the i shows where a source value lives.

#	Variable_id	Variable_title	Formula_id	Formula / value origin	Type
1	V-8	Refund amounts requested (latest 25) [11 values]	—	request[requestType=Refund]!amount [11 values]	Source data
2	V-14	Average refund requested [975.36]	IR-6	SUM() ÷ COUNT()	Calculated

Each variable in the order it was evaluated: sources first, then each formula with the values it used.

#1V-8Refund amounts requested (latest 25)Source data11 values EGP
Address: request[requestType=Refund]!amount · Field "amount" of the 11 latest request work cases where requestType is Refund
Values read (11)
- REQ-41!amount = 750.00 Demo: Customer order delivery / Cairo seasonal promotion
- REQ-26!amount = 1,500.00 Demo: Refund request / Urgent cold-chain exception
- REQ-25!amount = 1,250.00 Demo: Refund request / Cancelled supplier replacement
- REQ-24!amount = 1,000.00 Demo: Refund request / Completed October replenishment
- REQ-23!amount = 750.00 Demo: Refund request / Cairo seasonal promotion
- REQ-22!amount = 500.00 Demo: Refund request / Warehouse stock reconciliation
- REQ-21!amount = 250.00 Demo: Refund request / Alexandria branch opening
- REQ-17!amount = 750.00 Demo: PO Release / Cairo seasonal promotion
- REQ-11!amount = 750.00 Demo: Daily Supplier Recommendations Release / Cairo seasonal promotion
- REQ-5!amount = 29.00 Refund of a duplicated subscription charge
- REQ-1!amount = 3,200.00 Refund for a damaged shipment of 40 chairs
#2V-14Average refund requestedCalculated975.36 EGP
IR-6 · AR-6 Average refund requested: SUM(11 values) ÷ COUNT(11 values) = 975.36
Rounded (AR-13): ROUND(975.3636, 2) = 975.36