10 Replies Latest reply: Nov 10, 2016 4:18 AM by Denis V RSS

    Variables in sum

    Denis V

      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.