Sum (if) with two conditions

[Francisco Aspillaga]

Hi,

What will be the formula to add all the values with "CAT" C and A. The result should be 115.

 

Thanks¡

[Gaia Paolini]

is this meant to be a calculated column?

[Francisco Aspillaga]

Hi Gaia,

No, it is not a calculated column.

Regards,

[Gaia Paolini]

can you elaborate a bit of what it is meant to be?

[Jose Leviaguirre]

Hello Francisco. If it is not meant to be a calculated column, I assume is a calculated or aggregated value, so use something like this in your custom expression, function or whatever you are planning to use it on

Sum(If([CAT]~="A|C",[VALUE]))

The secret is the first argument of the if function. The ~= operator is used to test if the value in the "CAT" column matches the regular expression "A|C". In this regular expression, the vertical bar (|) means "or", so the regular expression matches either the character "A" or the character "C"

[Francisco Aspillaga]

Hi Jose,

Thanks for youre help¡