Multiply Column by Grid

[madisons82]

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%

[flying008 · Accepted solution]

Hi, @madisons82 

Try this formula and change output type to Double :

[Annual Value] * ToNumber(Replace([_CurrentField_], '%', '')) / 100