Equivalent for Not(in_range ).

[former_member728074]

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.

[denis_konovalov]

tags adjusted to better match question subject.

[DellSC]

Are you filtering out records that were received and rejected on the same day, or are you showing them but not counting them?

[former_member728074]

I am filtering them. ( your first option)

[ayman_salem]

v_s1: = If ([Order Received Date] = [Rejected Date]) then 0 else 1

v_count: =sum(v_s1)