Hi all ,
I have created a toggle .PFA the image. But some how toggle is not working.
Its giving only share metric value.
Please help.
Logic i am using
Num(
Round(
Sum(
{<
Report = {'General Campaign Data'},
Keyword =,
Currency =
>}
IF(Metric = 'Sales',
If([Currency Shown] = 'Euro', [Spend (€)], Spend),
If([Currency Shown] = 'Euro', [Sales (€)], Sales)))
, 1000) / 1000
, vFormatLocalCurrenciesRounded)