Hey guys,
I have created a form for my business and so far I have enabled it to calculate the product price (based on the product selected from a dropdown list of products), the warranty price (based on the warranty selected from the dropdown list) and taxes (based on the province selected from a dropdown list).
What I am doing now is I am trying to calculate the Total Sale. So basically the Sale price of the product + Warranty Price * the Taxes for that region. I am having a lot of trouble since I think its not possible to add the totals of formulas together??
Is there any way I can do this? Is it possible to store the values of these formulas somewhere else where I could use them in a formula for my Total Sale Price?
Any help is greatly appreciated...thanks!!