Jump to content

Sum (if) with two conditions

Francisco Aspillaga
Go to solution Solved by Jose Leviaguirre,

Recommended Posts

  • 2 weeks later...
  • Solution

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


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"

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...