Sigma Community

NOT Operator Functionality

Sigma Formulas and Functions

ztrean August 21, 2020, 5:59pm #1

I’m trying to use the NOT operator but i’m getting an error, do you see something that is wrong with the formula below?

SumIf([Revenue],In([Stock],“C2”) NOT In([Company Name],“Leo Limited”))

Ryan August 21, 2020, 6:01pm #2

Hey Zachary!

I believe the issue here is that you do not have an “AND” operator before your “NOT”. If you add this I think it should work!

system automatically bumped October 14, 2020, 7:44am #3

system automatically bumped October 28, 2020, 1:20am #4

system automatically bumped November 13, 2020, 1:34am #5

system automatically bumped December 2, 2020, 2:03pm #6

system automatically bumped December 22, 2020, 2:20am #7

system automatically bumped January 11, 2021, 6:10am #8

system automatically bumped January 31, 2021, 2:18pm #9

system automatically bumped February 22, 2021, 12:13am #10

system automatically bumped March 15, 2021, 10:24am #11

system automatically bumped April 6, 2021, 12:25am #12

system automatically bumped April 27, 2021, 2:16pm #13

system automatically bumped May 19, 2021, 10:07am #14

system automatically bumped June 10, 2021, 3:52pm #15

system automatically bumped July 3, 2021, 12:49pm #16

system automatically bumped July 26, 2021, 5:15am #17

system automatically bumped August 17, 2021, 8:28pm #18

system automatically bumped September 10, 2021, 8:32am #19

system automatically bumped October 3, 2021, 6:59pm #20