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.
