Variables in sum

[#1]

Hello,

Maybe can someone tell me what i am doing wrong. My task is to calculate sum of previous DrawID starting from today.

Right answer i get when do like this :  sum({$<DrawID = {'<3'} >}[Ticket.Amout] )

I defined  variable vCurrentEdition like this  Num#(if( DrawDate = today() , DrawID),'#.#', '.' , ','),  also tried if( DrawDate = today() , DrawID) both variations gives the right answer 3 .

To count sum i tried this variations:

sum({$<DrawID = {'< $(vCurrentEdition)'} >}[Ticket.Amout] )

sum({$<DrawID = {"< $(vCurrentEdition)"} >}[Ticket.Amout] )

sum({$<DrawID = {'< vCurrentEdition'} >}[Ticket.Amout] )

sum({$<DrawID = {"< vCurrentEdition"} >}[Ticket.Amout] )

sum({$<DrawID = {vCurrentEdition} >}[Ticket.Amout] )

Unfortunately none of them works. What should i do to count sum.

Thanks in advance. 

[sunny_talwar]

Can you try this:

Sum({$<DrawID = {'<$(=vCurrentEdition)'} >}[Ticket.Amout])

[#3]

Hello, thank for fast replay. It does not work

[sunny_talwar]

How about if you change single quotes to double quotes here?

Sum({$<DrawID = {"<$(=vCurrentEdition)"} >}[Ticket.Amout])

[Anonymous]

Try this one

=Sum({$<DrawID = {<$(=$(vCurrentEdition))} >}[Ticket.Amout])

[#6]

Already tried. does not work. Maybe something wrong with my variable

[#7]

Does not work. I also tried with different quotes.

=Sum({$<DrawID = { ' <$(=$(vCurrentEdition)) ' } >}[Ticket.Amout])

=Sum({$<DrawID = { " <$(=$(vCurrentEdition)) " } >}[Ticket.Amout])

[sunny_talwar]

May be share a sample so that we can dig deeper into the issue for you

[#9]

Sure. Here is my data, and calendar that i am using.

[tresesco]

Try putting '=' before expression while defining your variable.