Skip to main content

Hello,

 

I'm having issues with my negative integers. I'm not sure if they are being recognized.

 

I need to created a bucket which has two categories, Posted and Not Posted.

 

The formula is:

IF [Days until Launch Date]>=-168 AND [Days until Launch Date]<0 THEN 'Posted'

ELSE 'Not Posted'

END

 

However, it is showing numbers that are greater than -168 as "posted" (example listed below).

Negative Integers not being recognized?

 

Thank you and please assist!

 

Best,

 

Kinjal Brahmbhatt

5 answers
  1. Apr 16, 2020, 5:08 PM

    What happens if you change the condition to

    [Days until Launch Date]<-168 AND [Days until Launch Date]<0

0/9000