MetricKPI Compass StandardApprovedInternal
Return on Investment
Net gain from an investment divided by its cost.
Unit
percentage
Aggregation
ratio
Definition
Net gain from an investment divided by its cost.
Formula
(Investment Gain - Investment Cost) / Investment Cost
Assumed fields: {{numerator_expression}}{{denominator_expression}}{{numerator_measure}}{{denominator_measure}}
Return blank or null when the denominator is zero. Confirm filters, grain, and inclusion rules before production use. Tableau, Looker (LookML), and Datorama templates are generated from the canonical formula — confirm field references before production use.
Standard reference formula for Return on Investment.
Sources
No sources recorded yet.