topic Variables in sum in App Development

Variables in sum

Wed, 09 Nov 2016 08:32:13 GMT

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.

Re: Variables in sum

sunny_talwar — Wed, 09 Nov 2016 10:57:46 GMT

Can you try this:

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

Re: Variables in sum

Wed, 09 Nov 2016 11:39:11 GMT

Hello, thank for fast replay. It does not work

Re: Variables in sum

sunny_talwar — Wed, 09 Nov 2016 14:18:03 GMT

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

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

Re: Variables in sum

Anonymous — Wed, 09 Nov 2016 14:22:12 GMT

Try this one

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

Re: Variables in sum

Wed, 09 Nov 2016 14:25:15 GMT

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

Re: Variables in sum

Wed, 09 Nov 2016 14:34:16 GMT

Does not work. I also tried with different quotes.

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

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

Re: Variables in sum

sunny_talwar — Wed, 09 Nov 2016 16:46:15 GMT

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

Re: Variables in sum

Thu, 10 Nov 2016 07:31:25 GMT

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

Re: Variables in sum

tresB — Thu, 10 Nov 2016 08:02:16 GMT

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

Re: Variables in sum

Thu, 10 Nov 2016 09:18:56 GMT

Thanks for suggestion. I tried, but nothing changed.