Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Can you try this:
Sum({$<DrawID = {'<$(=vCurrentEdition)'} >}[Ticket.Amout])
Hello, thank for fast replay. It does not work
How about if you change single quotes to double quotes here?
Sum({$<DrawID = {"<$(=vCurrentEdition)"} >}[Ticket.Amout])
Try this one
=Sum({$<DrawID = {<$(=$(vCurrentEdition))} >}[Ticket.Amout])
Already tried. does not work. Maybe something wrong with my variable
Does not work. I also tried with different quotes.
=Sum({$<DrawID = { ' <$(=$(vCurrentEdition)) ' } >}[Ticket.Amout])
=Sum({$<DrawID = { " <$(=$(vCurrentEdition)) " } >}[Ticket.Amout])
May be share a sample so that we can dig deeper into the issue for you
Sure. Here is my data, and calendar that i am using.
Try putting '=' before expression while defining your variable.