Welcome to the Sage Construction and Real Estate products Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
How to write SQL statement for percentage in subtotal and total rows?
Getting % on detail rows is no problem, but when trying to get a % on the subtotal or total rows eludes me.
Any help on this would be greatly appreciated. Thanks so much!
If you have the Estimating module I believe you would start there. If you don't have the Estimating module I would suggest you use the Job Status field as your guide.
Bid (only if you want Sage keep track of all jobs you bid whether you win them or…