Rangesum all values small than

[#1]

I only know how to sum up values for one column using something like:

sum({<AMOUNT = {"<99"}>} AMOUNT)

What is the expression to rangesum columns only summing up values smaller than 99?

rangesum(data1, data2, data3, data4)

[#2]

Mhh right now I get back a 99.

To verify, can I somehow do set analysis like for year in that?

[jonathandienst · Accepted solution]

RangeSum is not a set aggregator, so you cannot use set expressions. You will need to use If or RangeMin expressions:

RangeSum(If(A < 99, A), If(B < 99, B))

or

RangeSum(RangeMin(A, 99), RangeMin(B, 99))

[tamilarasu]

At first glance, I misunderstood the question. You can use Jonathan's solution.

RangeSum(RangeMin(A, 99), RangeMin(B, 99), RangeMin(C, 99), RangeMin(D, 99))