GetFieldSelections returns Null() on multiple selections

[wynnjimbbt]

the expression and variables below work except when making multiple selections on fields [Ref Qualified Week Ending] or field [Week Ending]. Returns null() when making multiple selections on fields [Ref Qualified Week Ending] or [Week Ending]

vGetQualfWeekEnding =

if(GetSelectedCount([Ref Qualified Week Ending])>0,Date(GetFieldSelections([Ref Qualified Week Ending]),'MM/DD/YYYY'), if(GetSelectedCount([Week Ending])>0, Date(GetFieldSelections([Week Ending]),'MM/DD/YYYY'),'*'))

[wynnjimbbt]

Pradosh,

I still have trouble evaluating vGetQualfWeekEnding when 2 or more dates are selected:

ex.

=$(vGetQualfWeekEnding) returns 09/23/2017, 09/30/2017

=sum({$<  LogonID ={"*"}, [Week Ending] = {'$(=$(vGetQualfWeekEnding))'} >}[Target PMP Ref] ) returns a zero; there is data

=$(ePMPRefTarget) returns "Error in set modifier ad hoc element list: ',' or ')' expected"

ePMPRefTarget:

LogonID ={"*"},[Ref Qualified Date]=, [Ref Qualified Year]=, [Ref Qualified Quarter]=, [Ref Qualified Month]=, [Ref Qualified Week Ending]=, Advisor=, [Group]=, [Region Team]=,Year = {$(=max(Year))} , Quarter = { $(=$(vGetQualfQuarter))} , Month = { $(=$(vGetQualfMonth))}, [Week Ending] = {'$(=$(vGetQualfWeekEnding))'}

Thanks in advance! Hope you can help,

Jim

[pradosh_thakur]

=sum({$<  LogonID ={"*"}, [Week Ending] = {'$(=$(vGetQualfWeekEnding))'} >}[Target PMP Ref] ) put this in a text box or in a column without any label. hover on top of that and you can see how it is being evaluated . please post the screenshot.

and try this as well and post the screenshot. it will help understand the issue better.

=sum({$<  LogonID ={"*"}, [Week Ending] = {'$(vGetQualfWeekEnding)'} >}[Target PMP Ref] )