Sum function problem

[#1]

My problem is that i want to get the sum of my colums a and b but when i use the sum function to get the total of these columns in a textbox. I get a false total.

How can i bypass my problem and get the total of the colums in the textbox?

[sunny_talwar · Accepted solution]

Try it this way:

Sum(Aggr(If(BundgeProzent >100, 1, 0), yourChartDimensions))

list all dimensions where you see yourChartDimensions in the expression above