prior day vs today

[#1]

hi team

I'm having data as of july 2016 month. I need to create the comparision for today & yesterday. could some one help me out

[krishnacbe]

Hi,

Can you explain your requirement in details or share the input data and output format to help on this.

[#3]

hi

I'm having data as of 7th month. I need to calculate the yesterday & today varience

[krishnacbe]

Hi

You can calculate  the expression with Set modifier having Today() and Today()-1 and then find the variance between them.

Still if you add some input data it will help to resolve the issue.

[Jason_Michaelides]

See this post - Calendar with flags making set analysis so very simple

[saimahasan]

Please post sample data so that much accurate solution can be provided.

[#7]

Thank you Jason

[#8]

Thank you Krishnapiya

[#9]

Hi,

You will find infinite threads doing the comparisons based on Date using set analysis or alternate states.

check this out:

yesterday using today() in set analysis

Hope this helps.

Thanks,

Singh

[Anil_Babu_Samineni]

How about this

Today = Max(Date)

Previous = (Max(Date)-1)

Sum({$<Date = {"$Today) - $(Previous)"}>}Sales)