Set Expression with > sign not working

[walimmalik]

Hi,

I am trying to calculate total count of late started activities, by using a set expression with 2 conditions, the first checks if the activity is not started, and the second checks to see if the current date > planned start date.  Here is the expression im using.  What am I doing wrong?

count({$<ACTIVITY_STATUS = {'Not Started'}, [ACTIVITY_PLANNED_START.autoCalendar.Date] = {"< Date(Now())"}>} ACTIVITY_ID)

I know this works if i put the equivalent into an if statement for a table dimension.

Thanks.

[m_woolf]

try:

count({$<ACTIVITY_STATUS = {'Not Started'}, [ACTIVITY_PLANNED_START.autoCalendar.Date] = {"< $(=Date(Now()))"}>} ACTIVITY_ID)

Your Dates must be in the same format.

[vamsee · Accepted solution]

Try

count({$<ACTIVITY_STATUS = {'Not Started'}, [ACTIVITY_PLANNED_START.autoCalendar.Date] = Date ={"<=$(= Date#(Date(Today()), 'MM/DD/YYYY')) )"}

>} ACTIVITY_ID)

Make sure [ACTIVITY_PLANNED_START.autoCalendar.Date] is in the format of mm/dd/yyyy

Also I would like to suggest, use date num.

[walimmalik]

Thank you it worked as well.

[walimmalik]

Thank you, it worked!