topic Re: Set Expression with > sign not working in App Development

Set Expression with > sign not working

walimmalik — Thu, 30 Aug 2018 17:49:27 GMT

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.

Re: Set Expression with > sign not working

m_woolf — Thu, 30 Aug 2018 19:59:39 GMT

try:

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

Your Dates must be in the same format.

Re: Set Expression with > sign not working

vamsee — Thu, 30 Aug 2018 20:01:30 GMT

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.

Re: Set Expression with > sign not working

walimmalik — Thu, 30 Aug 2018 20:19:13 GMT

Thank you it worked as well.

Re: Set Expression with > sign not working

walimmalik — Thu, 30 Aug 2018 20:19:21 GMT

Thank you, it worked!