Skip to main content
Question

Percentage mix calculation

  • July 8, 2025
  • 2 replies
  • 58 views

Forum|alt.badge.img+1

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?

 

2 replies

Min Li
Master Helper
Forum|alt.badge.img+12
  • Master Helper
  • July 8, 2025

@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.


Nathan
Employee
Forum|alt.badge.img+12
  • Employee
  • July 9, 2025

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

So what is wrong with that ?