I have a report that I would like to add a column and then take a Material Type from another column and multiple it by a value. The variable is that Material Types change and the multiplier is different for each Material type.
Example: Material Type = Paper X by 200
Material Type = Wood X by 300
Material Type = Rock X by 500
What would the expression look like in the column I add?
Example: Material Type = Paper X by 200
Material Type = Wood X by 300
Material Type = Rock X by 500
What would the expression look like in the column I add?