Search results by user ID 6523

Change Estimate Line Total Amount Calculation

Randall Stephens — Fri, 12 Sep 2014 21:35:54 GMT

Is there a way to change how the Estimate Line Amount is calculated? The way it's set up now will not work for us. We need to show Unit Price on our estimates, and we cannot have a Unit Price that contains fractions of pennies.

The Amount column is currently calculated from the Quantity, Cost, and Markup. I need to calculate the Unit Price (Cost X Markup), and THEN calculate the Amount (Unit Price X Quantity). Can this be done?

Re: Grid Calculations

Randall Stephens — Tue, 05 Aug 2014 22:55:25 GMT

Hi Russell,

I've looked through the calculations on that page, and I don't see anything that looks like it will update the total amount. Yet, the total amount refreshes when the 'update' button is clicked. Can you tell me which action is causing this? If I can see what's causing the total amount on the line to update, then I'm sure I can make another column update as well.

Thanks,

Randall

Grid Calculations

Randall Stephens — Tue, 05 Aug 2014 20:32:33 GMT

Is it possible to run a loop through a grid that runs a basic calculation on two cells in each row and returns a result into a third cell in the same row?

Our estimate line has quantity and our cost per item. But I'd like to put in a column for our extended cost per line item. This doesn't seem to be doable with loops and action results, as the first line's extended cost will be placed in the action result but it won't repeat for each additional row.