Defines measures that combine values across topics after the join.
Defines measures that combine already-aggregated values from multiple topics in a single SQL expression. Each topic runs its own subquery first, so every ${@topic.view.field} reference is a single aggregated value by the time the shared measure sees it. Any field you reference is auto-included in the right subquery — you don’t need to also add it to the workbook.
Write the sql as plain math over already-aggregated values — arithmetic, CASE, COALESCE, NULLIF, etc. Each referenced field is already a single aggregated value, so wrapping it in SUM(...) or COUNT(...) or setting aggregate_type re-aggregates over the post-join result, which usually isn’t desirable.
The SQL expression combining topic-scoped fields, referenced as ${@topic_name.view.field}. Filters on a shared measure are applied as a WHERE on the post-join result.
The number format for the measure’s values. Accepts any Omni named format (for example, usdcurrency_2 or percent_2), an Excel-style string, or a conditional format.
