I need to create a new Column via Beast mode called % Sales Material based on the following calculation.
(Sales Price - Actual Cost) / Sales Price
I am struggling with the exact Beast Mode Code because Sales Price is on one Line Based on WTSTEP 000 And Actual Cost is on a Separate Line and is based on Beast Mode Where when WTSTEP = 010 it will take 'UnitCost' * 'QTY Ordered'