Set Analysis Error

[gouthamkk]

Hi,

I need assistance to convert below expression using Set Analysis

Current Expression:

Count(if(status='open', if ((target >= closedate), id)))

Note: closedate and target are date fields and are in same format.

I tried Below expression

Count ({<status= 'open', target = {">= closedate'}>} id)

But getting no values.

Request to assist

[Anonymous · Accepted solution]

You have different quotes here

{">= closedate'}>}

Edit:

And, I prefer this approach:

Count ({<status= {'open'}, target = {"$(='>=' &date(closedate))"}>} id)

[gouthamkk]

Thank you very much. sorry it was a typo on my end for different quotes.

Quick question is it mandatory to have "date" before  (closedate)

[Anonymous]

The date() function helps to keep format consistent.  Without it, it often converts to integer.  It maybe not necessary in your case, but I prefer to use it anyway.