Skip to main content

I’m trying to calculate fee % on the total amount. Both metrics have the same 5 dimensions. However my output when I directly calculate it as a formula is different from when I use Calculations “show value as” in the table which is correct.
Since both have the same dimensions, how do I get the correct % at all levels of the dimension?

The first is from “show value as” and the second is from a metric. How do I get both of these to be correct and the same?

 

​@keerthanaramesh Typically, when you calculate a percentage using a formula, it it computed at the lowest dimension level. However, when you place the metric in a table, and display it at a higher-level dimension, the percentages are aggregated (either by summing or averaging) at the higher level dimension. Hope it makes sense to you.

Show value As is the way to go for this, which you are doing already.

So what is wrong with that ?

 

Reply


Ask your question here!

Terms & ConditionsCookie settings