Calculated Columns Based on Text Field Data

[AaronMcClay1311]

Hello,

So I am trying to create a calculated column based on a field. What I am trying to see is how much we have spent on moving product within our warehouse. So if it costs $5 (this field would need to be able to change) how would I get it to calculate into the fields I already have? 

I have a picture below of the two tables and the text field I want to use to calculate.

Thank you

[JadhavVarsha_13 · Accepted solution]

Hello 

You can use what if parameter here, can you confirm what exactly you want to update if Cost of Movement is changed to diff value

[AaronMcClay1311]

That worked perfectly! I was trying to mulitply the Count of Transactions by the What if Value. I got exactly what I was trying to get! Thank you!