Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
May be something like this:
Count({<Code = {"=Len(Trim(Code)) > 0"}, EndDate = {"=Len(Trim(EndDate)) = 0"}+{"$(='>' & Date(Today(), 'YourEndDateFormatHere'))"}>} FieldYouAreCountingHere)
May be something like this:
Count({<Code = {"=Len(Trim(Code)) > 0"}, EndDate = {"=Len(Trim(EndDate)) = 0"}+{"$(='>' & Date(Today(), 'YourEndDateFormatHere'))"}>} FieldYouAreCountingHere)
Looks Perfect. Thanks a lot
Salute to you Boss....