calculations

[ntudev]

how would i get it to add another column to say Moved up or Moved Down if the numbers are different? 

AsOfDate	S&P Rating	Prior Month S&P	Moody Rating	Prior Month Moody	Movement
5/31/2022	90	10	1	0.0003	Moved down
5/31/2022	80	70	0.3835	0.1753	Moved Down
5/31/2022	54	80	0.0074	0.3835	Moved Up
5/31/2022	57	80	0.0141	0.3835	Moved Up
5/31/2022	70	60	0.1753	1	Moved Up

[IraWatt]

Hey @ntudev,

You can use a formula tool like this:

The community has some quick and easy videos on formulas and the Formula Tool here https://community.alteryx.com/t5/Interactive-Lessons/tkb-p/interactive-lessons/label-name/Writing%20... 

Any questions or issues please ask :)
HTH!
Ira

[ntudev]

is it possible to say, if it it moved by < >

.05 "Move Up by 1"

.10 "Move Up by 2"

.15 "Move Up by 3"

.50 "Move Up by 4"

1 Move Up by 5

.

[IraWatt]

@ntudev It definitely is possible though what do you mean by .05? does that mean Moody Rating-Prior Month Moody is between 0 and .05 or does it mean there is a 5% change?

[ntudev]

it doesnt matter as long as i see your formula, i'm just making things up that is similar to my project.

[IraWatt]

Ah okay here's an example:

I created a Change column to calculate the difference between the previous and current month. Then added a formula which adds 1,2 or 3 depending on the value of change.