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).
Thank you and please assist!
Best,
Kinjal Brahmbhatt
5 answers
What happens if you change the condition to
[Days until Launch Date]<-168 AND [Days until Launch Date]<0