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.

Reply


Ask your question here!

Terms & ConditionsCookie settings