Error in set modifier ad hoc element list: ',' or ')' expected ; GetSelection variables

[wynnjimbbt]

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

all other GetSelection variables work, and vGetQualfWeekEnding works with 1 date 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!

Jim

[sunny_talwar]

How is this defined?

vGetQualfWeekEnding

[Anil_Babu_Samineni]

Perhaps this?

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

[pradosh_thakur]

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

vGetQualfWeekEnding

=if(GetSelectedCount([Ref Qualified Week Ending])>0,
CONCAT(Distinct Date([Ref Qualified Week Ending],'MM/DD/YYYY'),chr(39)& ',' & chr(39)),
if(GetSelectedCount([Week Ending])>0, CONCAT(Distinct Date([Week Ending],'MM/DD/YYYY'),chr(39)& ',' & chr(39)),'*'))

[sunny_talwar]

How did you know what vGetQualfWeekEnding is?

[sunny_talwar]

Hahahahaha make sense... I was wondering where did you get that information from

Thanks for sharing this

[wynnjimbbt]

All,

vGetQualfWeekEnding:   this works;
returns 09/09/2017 with one date selected; 09/09/2017','09/16/2017 with two dates selected and * with no dates selected

=if(GetSelectedCount([Ref Qualified Week Ending])>0,
CONCAT(Distinct Date([Ref Qualified Week Ending],'MM/DD/YYYY'),chr(39)& ',' & chr(39)),
if(GetSelectedCount([Week Ending])>0, CONCAT(Distinct Date([Week Ending],'MM/DD/YYYY'),chr(39)& ',' & chr(39)),'*'))

evaluating vGetQualfWeekEnding below:   this fails;
returns Error in set modifier ad hoc element list: ',' or ')' expected

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

Jim

[sunny_talwar]

Can you try this without the red single quotes

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

So, essentially try this

=Sum({$< LogonID ={"*"}, [Week Ending] = {$(=Chr(39) & $(vGetQualfWeekEnding) & chr(39))}>}[Target PMP Ref] )

[wynnjimbbt]

without the single quotes this returns the error message:

Error in set modifier ad hoc element list: ',' or ')' expected