I have created a Wholesale Pricelist that has all of my SKUs listed, dealer cost, MSRP, QTY that you want to buy, then I have a column for the total per item, that will later add up to an expected grand total. What I need your help with is how do I multiply the fixed dealer cost field (position is column 6 for each line) by the variable QTY field (column 8) to get a total (column 10) for each line?
Thanks in advance!!
Can you share file, or be more specific pls?
Sure. Here you can see that we have a column "cost" that needs to be multiplied by "quantity" and the answer to be placed in total.
Can't you use simplified field notation in total field: cost*quantity? change cost and quantity with your field names