Forum Discussion
Calculated Columns Based on Text Field Data
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
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
2 Replies
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
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!