Hello,
I am trying to solve a problem where I need to multiply the value in the column "Annual Value" by a column I have for each date for every day in 2025. I suspect I need to use a multi-field formula but haven't had any luck yet. Essentially, I have a data table of many stores along the rows, the predicted annual volume for each store, and then the % of annual volume in each of 365 additional columns that represent each day of 2025. I need to estimate the annual volume on a daily level without 365 separate calculations (lol). Any help hugely appreciated!!
This is an over simplified example of the data but there is a column for each day of the year:
| Store | Annual Value | 1/1/2025 | 1/2/2025 | 1/3/2025 |
| Store 1 | 654 | 1.20% | 0.83% | 0.95% |
| Store 2 | 1184 | 1.20% | 0.83% | 0.95% |
| Store 3 | 236 | 1.20% | 0.83% | 0.95% |
| Store 4 | 597 | 1.20% | 0.83% | 0.95% |
| Store 5 | 1387 | 1.20% | 0.83% | 0.95% |
