Decimal range for output

aka_ash

Hi,

I am trying to get an output from comparing 2 sets of data.

There 2 sets of data are decimals, I would like to flag anytime the data has moved from below 0.2 to above 0.2 and anytime the data has moved to the next threshold/range of 0.1 below or above (0.2 - 0.3, 0.3 - 0.4, 0.4 - 0.5 etc.).

I have some sample data and a desired output below.

Yesterday	Today	Output
0	0.29	Change up to threshold 0.2
0.18	0.19	No Change
0.21	0.34	Change up to threshold 0.3
0.84	0.79	Change down to threshold 0.7
0.54	0.52	No change
0.28	0.31	Change up to threshold 0.3
24.23	24.11	Change down to threshold 24.1
2.43	0.22	Change down to threshold 0.2

Thanks in advance,

Ash

pedrodrfaria

Hi @aka_ash 

I attached the WF below. You can see by the Output Alteryx column, it matches with how it was supposed to be. Let me know if you have trouble understanding the functions used.

Pedro.

Decimal range for output.yxmd