Set Analysis with variables

[jorgelardi]

I want to use a variable in my Set Analysis.

I created the variable Tomorrow by defining it as Today () + 1

Then I use the following expression:

= Sum ({$ <delivery_date = {'$ (= Tomorrow)'}>} QuantityProduction) but I can not get consistent values

Can someone help me?

Jorge

[jorgelardi]

dd/mm/yy

[vishsaggi]

Did you try this?

= Sum({< delivery_date = {"$(=Date(Tomorrow, 'dd/mm/yyyy')) " } >} QuantityProduction)

[jcampbell474]

Ok, in your load script or the variable editor, try: Let Tomorrow = Date(Today(1)+1,'dd/mm/yy')

[passionate]

How do you set past tomorrow value.

As, your vtomorrow = Today()+1 So, the Result of Set Analysis will always remain same

[juan_patrick]

Jorge,

Después del signo $ los espacios no deben existir!

¡Saludos!

[jorgelardi · Accepted solution]

Thank you all !! I discovered my error. I had badly defined the variable Tomorrow in the script

[Anil_Babu_Samineni]

Please make sure to create variables in script. And then use. Meanwhile, I would ask you to mark helpful from the thread if you feel to get as you expected.