Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
try:
count({$<ACTIVITY_STATUS = {'Not Started'}, [ACTIVITY_PLANNED_START.autoCalendar.Date] = {"< $(=Date(Now()))"}>} ACTIVITY_ID)
Your Dates must be in the same format.
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.
Thank you it worked as well.
Thank you, it worked!