The below table columns are separated by ' | '.

 

﻿﻿Component | Required | UOM | Cost | Amount
124532 | 4 | PCS | .24 | .48
3324532 | 2 | PCS | 1.4 | 2.8
424532 | 1 | PCS | 2 | 2

 


replace the Amount column with this format [amt:formula].