Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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:
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]) )