OR in set analysis

[apthansh]

How to put OR between 2 dates in the below set analysis ?

(Count({<

          [Activity Status] ={'Active'},

                [ Plan] = {"$(='>' & Date(Today()))"} or [Revised] = {"$(='>' & Date(Today()))"}

   >} [ID]) )

If I do as below few ID's will get counted twice...

(Count({<

          [Activity Status] ={'Active'},

                [ Plan] = {"$(='>' & Date(Today()))"}

   >} [ID]) ) 

+

(Count({<

          [Activity Status] ={'Active'},

               [Revised] = {"$(='>' & Date(Today()))"}

   >} [ID]) )

Thanks Much

[sunny_talwar]

May be like this:

Count({<[Activity Status] ={'Active'}, [ Plan] = {"$(='>' & Date(Today()))"}>+<[Activity Status] ={'Active'}, [Revised] = {"$(='>' & Date(Today()))"}>} [ID])

Read about the the set analysis operators here:

Implicit Set Operators

[sergio0592]

Try this (Sunny has helped me on a similar problem last week)

(Count({<  [Activity Status] ={'Active'}, [ Plan] = {"$(='>' & Date(Today()))"}> + <[Activity Status] ={'Active'}, [Revised] = {"$(='>' & Date(Today()))"}  >} distinct [ID]) )