[Doug McLean]

I just checked this and it worked out fine.
I set a Material 1 and a Material 2 Custom Column and gave them each a value.
Then I build a total column with the formula (Measurement*Material 1)+(Measurement*Material 2)

To save yourself some headaches, I would put your materials and their cost into a csv file for easy import.