CTR on Banner

Hi, this is actually a very simple fix 🙂

So there's 2 things here...

You don't actually have to multiply by 100... just change your calculated metric's format to percent:

This will do that part of the math for you.

Second, the reason your numbers are looking odd is because your calculation is the decimal portion of cell, the percentage that is showing isn't your calculation at this point, it's the percent calculation of your row value against the total...

So looking at your total "5.91" (is the average percent for all your rows, displayed as a decimal), and your row 1 value "11.68" (is the percent displayed as a decimal) followed by % against the total calculation... 11.68 is 197.6% of 5.91.

Changing your values format to percent has multiple benefits:

1. It will do the multiply by 100 for you
2. It will actually display your results as percentages (i.e. 5.91% or 11.68%, etc.)
3. You will no longer see the percent calculation against your total... "percent" metrics show only the percent (not the number) and that percent is now your expected calculation.