I have a database that tracks jobs for a company, some in the proposal stage some already started.
I have a field that is called Status, with a drop down to choose either Proposal or Backlog.
The database tracks the Ending Balance, Cost, and Profit
along with some other things.
What I want to...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.