Calculate Ratios

Hi,

Something like this would work, for instance % of cases per dimension adding up to 100%.

Case count / GLOBAL (Case Count)

Hi @Yuyao Wang,

Not sure what your formula and situation is, but the formula 'FILTER_TO_NULL' is always fruitful if you want to apply filters on calculations. This function maps all field to NULL if they have a superior filter applied. If this is applied to both your denominator and divisor, it should bring the total to 100% again.

Hope this helps,

Jan-peter

Hi, Jan-peter

Thank you so much. I have a table like below. My formula originally is 'SUM("table"."column") / <%=variable%>', I use static value as SUM("table"."column") for the variables. When I apply the filter with dropdown list, the static value apparently can't be filtered.

This table shows the sum up data of my whole table, what I want to do is that when I select one thing from dropdown list, this table shows the data for the specific thing I selected. And the percentage is recalculate as each data divided by the sum of the data. E.G. scope1/(scope1+scope2+scope3) for the one I selected with dropdown list.

Hi, Pim

Thank you so much. I have a table like below. My formula originally is 'SUM("table"."column") / <%=variable%>', I use static value as SUM("table"."column") for the variables. When I apply the filter with dropdown list, the static value apparently can't be filtered.

This table shows the sum up data of my whole table, what I want to do is that when I select one thing from dropdown list, this table shows the data for the specific thing I selected. And the percentage is recalculate as each data divided by the sum of the data. E.G. scope1/(scope1+scope2+scope3) for the one I selected with dropdown list.