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 · Accepted solution]

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.

[Qiu]

@aka_ash 
I assume by 'No Change' means the data from column 'Today'.

[aka_ash]

Thanks @pedrodrfaria and @Qiu.

The first solution was able to produce what i was looking for.

[Qiu]

@aka_ash 
Glad to help and thank you for the accept mark.😁