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

[Anil_Babu_Samineni]

May be this?

= Sum ({$ <delivery_date = {'$ (Tomorrow)'}>} QuantityProduction)

Remove = symbol in variable or use two $ symbol around variable

[passionate]

Try Using

= Sum ({$ <delivery_date = {"=$ (= Tomorrow)"}>} QuantityProduction)

[vishsaggi]

What is your date format for your delivery_date?

= Sum({< delivery_date = {"$(=Date(Tomorrow, 'Yourdeliverydateformat here')"} >} QuantityProduction) like

= Sum({< delivery_date = {"$(=Date(Tomorrow, 'MM/DD/YYYY') " } >} QuantityProduction)

[jcampbell474]

You can try this:

In the load script or variable editor:

Let Tomorrow = Date(Today(1)+1)

Expression:

=Sum ({<delivery_date = {'$(Tomorrow)'}>} QuantityProduction)

[jorgelardi]

Thanks for your help, but it throws me a zero value

[jorgelardi]

Thanks for your help, but while it gives me correct results for the Tomorrow variable, it gives me the same results for the variable Past Tomorrow which is incorrect

[jorgelardi]

I throw the following error: "Error in set modifier ad hoc element list; ',' or ')' expected

[jorgelardi]

Thanks for your help, but it throws me a zero value

[jcampbell474]

How is your date displayed?  mm/dd/yyyy ???