Hello,
i have a input file with list of all years data in columns. i am using below formula to pick current year -
[Name] = ToString(DateTimeYear(DateTimeToday()))
now challenge is in every year i have to pick new column (because of new year). my question is how can i rename current year column to "CY" (i mean Column 2025 to CY) other wise i have to modify my workflow in every year (llike in January 2026 i have to update my workflow SELECT tool in multiple places from 2025 to 2026)
| Item | Product | Yes/No | 2022 | 2023 | 2024 | 2025 | 2026 | 2027 | 2028 |
| AB | 24 | Y | 16.00 | 80.00 | 6,767.00 | 6,751.00 | 6,671.00 | 6,751.00 | (16.00) |
| CD | 32 | N | 32.00 | 160.00 | 13,534.00 | 13,502.00 | 13,342.00 | 13,502.00 | (32.00) |
| EF | 46 | Y | 64.00 | 320.00 | 27,068.00 | 27,004.00 | 26,684.00 | 27,004.00 | (64.00) |
| GH | 68 | N | 128.00 | 640.00 | 54,136.00 | 54,008.00 | 53,368.00 | 54,008.00 | (128.00) |
| AB | 79 | Y | 256.00 | 1,280.00 | 108,272.00 | 108,016.00 | 106,736.00 | 108,016.00 | (256.00) |
| CD | 93.6 | N | 512.00 | 2,560.00 | 216,544.00 | 216,032.00 | 213,472.00 | 216,032.00 | (512.00) |
| EF | 108.2 | Y | 1,024.00 | 5,120.00 | 433,088.00 | 432,064.00 | 426,944.00 | 432,064.00 | (1,024.00) |
| GH | 122.8 | N | 2,048.00 | 10,240.00 | 866,176.00 | 864,128.00 | 853,888.00 | 864,128.00 | (2,048.00) |
| AB | 137.4 | N | 4,096.00 | 20,480.00 | 1,732,352.00 | 1,728,256.00 | 1,707,776.00 | 1,728,256.00 | (4,096.00) |
| CD | 152 | Y | 8,192.00 | 40,960.00 | 3,464,704.00 | 3,456,512.00 | 3,415,552.00 | 3,456,512.00 | (8,192.00) |
| EF | 166.6 | Y | 16,384.00 | 81,920.00 | 6,929,408.00 | 6,913,024.00 | 6,831,104.00 | 6,913,024.00 | (16,384.00) |
| GH | 181.2 | Y | 32,768.00 | 163,840.00 | 13,858,816.00 | 13,826,048.00 | 13,662,208.00 | 13,826,048.00 | (32,768.00) |
| AB | 195.8 | N | 65,536.00 | 327,680.00 | 27,717,632.00 | 27,652,096.00 | 27,324,416.00 | 27,652,096.00 | (65,536.00) |
Thank you
Kauser
