Database & utility
Macro
weighted_avg()
Arguments & returns
weighted_avg(value, weight)
Macro
| Overload link | value | weight |
Returns |
|---|---|---|---|
| #01 | unknown | unknown |
unknown |
Definition
(
sum(("value" * weight)) / sum(
CASE
WHEN (("value" IS NOT NULL)) THEN (weight)
ELSE 0
END
)
)