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

[wynnjimbbt]

Variable definition in QVW:

Text box:

Text box: evaluate variable:

[sunny_talwar]

Remove the equal sign from variable definition

And then try this in a text box object =$(vGetQualfWeekEnding)

[wynnjimbbt]

Sunny, Thank you!
the variable definition is CORRECT.

the sum statements fail in a text box but the variable works with my existing logic.

[sunny_talwar]

Super cool... I am glad we managed to get the solution in the end

[pradosh_thakur]

looks like we got the solution !! Though never had any doubt that it wont ..

[ddourguin]

Hello, 

I have the same error but cannot find the solution : 

sum

(

{

$

<[Solde*] =

{

=Sum(

{1
<[Comptes_5*] = {'YES'}>
}

[Solde*] )

< 0

}

>

}

[Solde*] )