Skip to Content
0
Mar 09, 2021 at 07:25 PM

Equivalent for Not(in_range ).

32 Views Last edit Mar 09, 2021 at 07:26 PM 2 rev

I am recreating a calculation from Cognos.

Cognos equation:

not([Rejected Date - Order Received Date] in_range{000 00:00.000:01 00:00:00.000})

The goal of the equation is we don't want to count it if it is received and rejected on the same day. I created a variable= [Rejected Date - Order Received Date] and was attempting to resolve it with DaysBetween.