Francisco Aspillaga Posted February 24, 2023 Share Posted February 24, 2023 Hi,What will be the formula to add all the values with "CAT" C and A. The result should be 115. Thanks¡ Link to comment Share on other sites More sharing options...
Gaia Paolini Posted February 27, 2023 Share Posted February 27, 2023 is this meant to be a calculated column? Link to comment Share on other sites More sharing options...
Francisco Aspillaga Posted March 9, 2023 Author Share Posted March 9, 2023 Hi Gaia,No, it is not a calculated column.Regards, Link to comment Share on other sites More sharing options...
Gaia Paolini Posted March 10, 2023 Share Posted March 10, 2023 can you elaborate a bit of what it is meant to be? Link to comment Share on other sites More sharing options...
Solution Jose Leviaguirre Posted March 10, 2023 Solution Share Posted March 10, 2023 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 onSum(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" Link to comment Share on other sites More sharing options...
Francisco Aspillaga Posted March 14, 2023 Author Share Posted March 14, 2023 Hi Jose,Thanks for youre help¡ Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now