I need to set up three different calculations. Is it possible to do it in one Query?
First I need to add two fields to get a quote total,
then I need to add two different fields to get a Cost Total
Lastly, I need to be able to give a %profit, by subtracting the Cost Total from the Quote, and then dividing that answer by the Quote.
Pretty confusing, I have gotten the first Quote total, however, I am not at all sure how to do the other two.
I would appreciate any help on this one.
First I need to add two fields to get a quote total,
then I need to add two different fields to get a Cost Total
Lastly, I need to be able to give a %profit, by subtracting the Cost Total from the Quote, and then dividing that answer by the Quote.
Pretty confusing, I have gotten the first Quote total, however, I am not at all sure how to do the other two.
I would appreciate any help on this one.