Hey Trevor,

we voted on that and the best way is:

Create Mapping:*name* metrics

In your formula do:

Forecast revenueeby:MappingMetric] + SalaryrbyMappingMetric2] etc etc

It is the most efficient way and the clearest. Only annoying thing is you have to create metrics for it.

Thanks @Nathan and team!

So I would create a metric with which dimensions? Month? And the value would be type: Dimension, IS_Account?

I would then take my IS_Account dimension in total and do a variety of Sums across, for example:

‘Forecast Revenue Total’ oby: Revenue_Mapping] + ‘Forecast Variable COGS Total’ Gby: Variable_COGS_Mapping] etc. for each of the lines?

Definitely a slog to set up, but I guess once the mappings are made I can easily manage them in a table and map new calculated item metrics to them. Hmm.

It would be interesting to have a feature like this, in which the IS_Account and BS_Account dimension lists could be mapped against Metric Names essentially. So the ability to use the Metrics themselves as a dimension list, updated as you create new metrics. I could just have a metric of dimension ‘Metrics Dim List’ and values Dimension, IS_Account and select which IS_Account matches each metric all in one place.

Thanks for the tip!

Without dimension ! this way you can use them easily (though you could make your mapping by year/version if you wanted it flexible but that might be overkill)

“

‘Forecast Revenue Total’ tby: Revenue_Mapping] + ‘Forecast Variable COGS Total’ Sby: Variable_COGS_Mapping] etc. for each of the lines?

Definitely a slog to set up, but I guess once the mappings are made I can easily manage them in a table and map new calculated item metrics to them. Hmm.”

You got it.