Hi Alteryx Community,
Wanting to know how can we apply the same formula across the columns and rows without painstakingly writing individual formulas for each field
If the sum of the day (18/02/2019) and the next five days is greater than of equal to 6, then the result for 18/02/2019 is "Y", otherwise, "N".
Thankyou.
Input
| | 18/02/2019 | 19/02/2019 | 20/02/2019 | 21/02/2019 | 22/02/2019 | 23/02/2019 | 24/02/2019 | 25/02/2019 | 26/02/2019 | 27/02/2019 | 28/02/2019 | 1/03/2019 | 2/03/2019 | 3/03/2019 | 4/03/2019 | 5/03/2019 | 6/03/2019 | 7/03/2019 | 8/03/2019 |
| item 1 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 1 |
| item 2 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| item 3 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
Output
| | 18/02/2019 | 19/02/2019 | 20/02/2019 | 21/02/2019 | 22/02/2019 | 23/02/2019 | 24/02/2019 | 25/02/2019 | 26/02/2019 | 27/02/2019 | 28/02/2019 | 1/03/2019 | 2/03/2019 | 3/03/2019 | 4/03/2019 | 5/03/2019 | 6/03/2019 | 7/03/2019 | 8/03/2019 |
| item 1 | N | N | Y | Y | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N |
| item 2 | Y | Y | Y | Y | Y | Y | Y | N | N | N | N | N | N | N | N | N | N | N | N |
| item 3 | N | N | N | N | N | N | N | N | N | N | N | Y | Y | Y | N | N | N | N | N |
