I am trying to create a view to create estimates, but I am having trouble with the expressions. I’ve tried to search around a bit, but can’t find my particular example. Can anyone help me out with the expression to calculate the total?
I want to add the price of 4 items and quantities to equal a total.
Example: (item 1 price * item 1 qty) + (item 2 price * item 2 qty) + (item 3 price * item 3 qty) + (item 4 price * item 4 qty) = total
Item prices are in a table named “Specbook”, columns are “SKU” and “SKU price”