community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

Formula issue

Asteroid

Hello All,

 

I have created the 3 new months variables,
Using 3 variables i would planning to pull the 3 latest months data.its not working for me. i have attached the sample file any suggestions please

 

Thanks in Advance

N S

Asteroid

The comparison you use for the VcurrentMonth , VpreviousMonth and vPreviousMonth2 is wrong as once you use datetimeadd it also adds the strong for hh:mm:ss towards the end you would need to reformat the filed value to be in the same format as your vMonth field something like this

 

datetimeparse(Todate(DateTimeAdd([vMonth],0,"month")),"%y/%m/%d")

 

However since you have alreadysummarized on max date not sure you can get anyvalue on the previousmonth and previousmonth2 .

Labels