D-Tools Forum - View Single Post

AVIR · 01-20-2010, 07:57 PM

Frye, your report I downloaded Labor Not Showing in Line Item Detail looks great, but I have problems with it. For example, I have a location with equipment at $20, and the Equipment total is $20.80. This is the 4% I have as misc parts. This means the totals aren't adding up.

What I need is for the labor and equipment to sum separately with a subtotal combining them.

So far I have: Equipment total, Installation labor total, and a location Subtotal. Unfortunately they do not add up.

Why? The Misc labor doesn't get added with dtr:LaborPrice and everything gets added (misc, EQ+/-, PM, Design) with dtr:InstallationPrice

I need to find the elusive DataField that included all labor and equipment, minus misc parts. We're OK with Misc parts being totaled at the bottom.

In fact our old reports would have a final system summary on the last page, like the Proposal Summary report, and it would total up completely so you could take all of the numbers and add them up for the grand total.

01-20-2010, 07:57 PM	#14 (permalink)
AVIR Member Join Date: Mar 2006 Posts: 58	Frye, your report I downloaded Labor Not Showing in Line Item Detail looks great, but I have problems with it. For example, I have a location with equipment at $20, and the Equipment total is $20.80. This is the 4% I have as misc parts. This means the totals aren't adding up. What I need is for the labor and equipment to sum separately with a subtotal combining them. So far I have: Equipment total, Installation labor total, and a location Subtotal. Unfortunately they do not add up. Why? The Misc labor doesn't get added with dtr:LaborPrice and everything gets added (misc, EQ+/-, PM, Design) with dtr:InstallationPrice I need to find the elusive DataField that included all labor and equipment, minus misc parts. We're OK with Misc parts being totaled at the bottom. In fact our old reports would have a final system summary on the last page, like the Proposal Summary report, and it would total up completely so you could take all of the numbers and add them up for the grand total.