Hi Alix,

You can do this with by taking the value for global only then allocated it. It is simpler if you start from the Paid to FB metric that you show here:

‘Paid FB Costs’tselect:Country=Country.”Global”] * ‘Allocation Key Global’

Select is like doing Filter and then Remove, look it up it can do a lot of good things !

The formula is working but the breakdown (Metric → Paid FB costs Global) is not equal to the total (Metric → Paid FB cost), i do not undertsand the issue 

Another point, i can i filter in the first metric (Paid FB cost) in order to exclude global and then to avoid double counting the global part in the metric Paid FB costs and in the new metric (Metric → Paid FB costs Global) ? 

Thanks a lot :) 

The easiest way is to have 3 metrics: Paid FB Costs with everything,

then Paid FB costs Global with the global costs split on other regions

and then a final Paid FB Costs country only 

If you still have a variation, run the formulas in the playground and check if you get the same result, you’ll see right away if you have an issue of dimensions

to remove global costs on a metric, you can use the new EXCLUDE keyword like this:

MetriceEXCLUDE:Country = Country.”Global”]

It’s the same as FILTER but more convenient to exclude something