topic Set Analysis GetFieldSelections with date problem in App Development

Set Analysis GetFieldSelections with date problem

mikeslade — Thu, 09 Aug 2018 12:24:42 GMT

Afternoon all

Need a little guidance to get this working, being trawling questions and can't get this to work. I'd like to use getfieldselections in the calculation.

This works:

Count({<WeekEnding ={'05/08/2018'}>}distinct ID)

I want to replace '05/08/2018' to work off a filter pane of a field called StartDate

Something like this:

Count({<WeekEnding ={date#(GetFieldSelections('StartDate'),'DD/MM/YYYY')}>}distinct ID)

Anyone able to help?

Thanks in advance.

Re: Set Analysis GetFieldSelections with date problem

sunny_talwar — Thu, 09 Aug 2018 16:36:19 GMT

Try this

Count({<WeekEnding ={"$(=Date(Max([StartDate]), 'DD/MM/YYYY'))"}>} DISTINCT ID)

Re: Set Analysis GetFieldSelections with date problem

mikeslade — Thu, 30 Aug 2018 09:39:54 GMT

Thank you! Apologies for the delay in response!