I'm sorry, but according to the knowledge sources, you cannot nest a formula metric inside another formula in Mixpanel. When constructing a new formula, you can only reference the base metrics (such as events, profiles, funnels, retention, or cohorts) that are present in your report, not other formulas. Specifically:
For referencing calculated metrics (like formulas, funnels, or retention metrics) inside another report, you can save these behaviors (if you are on a paid plan) and then reuse them across reports. However, this applies to funnel and retention behaviors, not formulas:
In summary:
- You cannot reference a formula inside another formula.
- You cannot reference calculated metrics (formulas) inside another formula.
- You can save and reuse funnel and retention behaviors across reports, but not formulas.
If you need to use a complex calculation, you must build it as a single formula using the available base metrics in your report.
