We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

formula explanation simple terms

chiragpatel_1
8 - Asteroid

Can someone please explain to me, simply, what the formula means/ what it is doing and are there any alternative ways.

 

chiragpatel_1_0-1650549712645.png

Thank you .

2 REPLIES 2
Luke_C
17 - Castor
17 - Castor

Can you include some data please. It looks like it's trying to assign a period to a given date. 

dYoast
11 - Bolide

It is subtracting 3 months from a field [To Date] and the current day, then it gets the year and month from both fields.

The year is multiplied by 100 and then added to the month - 2022-03-01 becomes 202200+03=202203

The MAX determines which value is greatest.

 

There may be alternative ways such as using DateTimeFormat to generate the value instead of the multiplication and addition.  It may depend on what is done with the value in your workflow.

Labels
Top Solution Authors