>Today, AND, OR Condition in set analysis

[malimohammed]

Hello,

I need a set analysis expression for a condition but unable to accomplish it.

count( if (Code is not null) and (EndDate is null or greater than today))

I would appreciate if anyone can help me on this.

[sunny_talwar · Accepted solution]

May be something like this:

Count({<Code = {"=Len(Trim(Code)) > 0"}, EndDate = {"=Len(Trim(EndDate)) = 0"}+{"$(='>' & Date(Today(), 'YourEndDateFormatHere'))"}>} FieldYouAreCountingHere)

[malimohammed]

Looks Perfect. Thanks a lot

[prma7799]

sunindia‌

Salute to you Boss....